db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: DatabaseMetaData.getColumns() with specified schema name gives poor performance
Date Tue, 24 Oct 2006 17:28:45 GMT
Andy Jefferson wrote:

>The schema in Apache JDO is created specifying lowercase identifiers but they 
>haven't quoted the identifiers so will be stored UPPERCASE in Derby.
>
>If I call
>DatabaseMetaData.getColumns(conn, null, "DATASTOREIDENTITY0", null);
>it returns in the order of 170000ms with the correct results for the selected 
>schema. 
>
>
>I personally consider 3 minutes just to give basic schema information (of a 
>schema that is *not* particularly big) to be totally unacceptable.
>
>
>2. Can I register it as a bug?
>  
>
Please open a jira issue for this. If you can provide a standalone repro 
for the problem,  that would be helpful.
Junit tests are welcome.

Thanks,
Sunitha.

Mime
View raw message