Subject Re: Slow execution of first query
Author Adam
--- In, "Nico Callewaert" <ncw@p...>
> Hi all,
> I'm having a performance problem. After powering up the computer and I
> execute a certain query the first time, it takes about 30 seconds to
> have the result set. When I open the query again, it takes only 3
> seconds. After searching the newsgroups, I've found that this
> performance issue is related to loading of metadata, triggers, SP,
> etc...

Hmmm, some information on the Firebird version, server type and OS
version may come in handy.

Now, here are a couple of things to check.

Assuming windows OS of some breed.

1. Does your database have a .gdb extension? If so this is your
problem. Rename it to .fdb.

2. Do you have volume shadowing enabled on Win2003 server? If so, you
will need to move the database to a volume that is not shadowed.

3. There was at one stage an issue with Hyperthreading. I am not sure
when or if it was resolved, but I haven't come across it in a long
time so I suspect it has. But if all else fails, switch off

The first time a query is executed, obviously it will need to load
various pieces of information that it may not need to do in subsequent
queries, but this will not take 30 seconds, maybe 1 or 2 for the first

When is the delay? Is it really running the first query, or is it
establishing the first connection or transaction etc.


> This problem only occurs after rebooting. So, is there a way I can
> force to load all of that stuff at startup time of the application ?
> So, I can have a good speed all the time.
> Thanks a lot in advance,
> Nico Callewaert