HomeActive Query Builderdelays Oracle

delays Oracle


Hi All

I am using ZEOS with Turbo delphi
I have since when access a BD Oracle Active Query Builder delays to be loaded with other DB does not have this delay some can modify something to improve the performance with Oracle?

Thanks

Edmilson
Edmilson | email
September 24 2007, 02:41 AM
Dear Edmilson,

Oracle is a heavy server, even the Express edition. Our component executes the 'select * from all_objects' query to fetch all database objects to the Metadata Container. You may try to execute this query via your ZEOS connection and see if its execution is fast enough. You can also use the metadata filter to reduce set of objects processed by the Metadata Container: try to exclude objects from system schemes; this can speed up the loading process.

If your database structure changes rarely, you can prepare the metadata information cache by saving the Metadata Container contents to the XML file and load it on the application startup.

Hope this helps.
Sergey Smagin | email
2 days, 2 hours since original post
Hi
Hi,
Sergey Smagin

This command in Oracle that was giving the delay in the reply
I removed this line when use Provider for Oracle and the delay was reduced

QueryBuilder.RefreshMetadata

Thanks

Edmilson
Edmilson | email
5 days, 14 hours since original post
This topic is closed