At 01:17 PM 28-11-02 +0000, you wrote:

>The schemacachedir was already disabled (blank). In the contrary,
>after I enabled it, the initial open speed increased as it doesn't
>load the metadata on subsequent connections. However, there are
>errors when running in the IDE, it looks like the IBO$SCHEMA_VERSION
>table is missing. I cannot find the details of this table, so I
>cannot create it manually (I tried to call
>SchemaCache.CheckSchemaVersionTable, but it failed). Attached is my
>monitor output:

[snip]
It's another issue...you can re-enable schema caching if and when you want to.

However, if you are getting a query on the system tables before a query
opens the first time, it looks as if you have GetServerDefaults set
true...this will slow down your query, for sure. I *never* use it. IBO
allows you to inform your connection object of all of the defaults for all
tables. I do it that way. I don't want to waste bandwidth getting
defaults for a query the user may not intend to update.

There is certainly something going on there to slow things down. It
shouldn't take 5 seconds to do the GetServerDefaults query...unless you
have some very huge values assigned as defaults, of course.

Now that we know you have the monitor running, how about posting a clip
from the output, showing the plan for your slow query?

Helen

Helen