Developing Tools and Using Cloudscape with an IDE
Page 4 of 5

Storing DatabaseMetaData Queries

Database tools sometimes use the JDBC DatabaseMetaData calls, which use complex SQL-J queries to return information about the DBMS and database. You can improve the performance of such applications using Cloudscape databases by storing precompiled versions of those queries in the database.

For information, see cloudscape.jdbc.metadataStoredPreparedStatements in Tuning Cloudscape.