Subject Re: Slow execution of first query
Author Nico Callewaert

Thanks for the info. The Firebird build is It is
running local on a Windows XP machine. DB connectivity is done using
FIBPlus. The extension is FDB and no shadowing.
The delay is happening only when the first time the form is opened.
The connection to the database is established already at that point.
I will try the hyperthreading. Anything I can check still ?

Thanks a lot,


--- In, "Adam" <s3057043@y...> wrote:
> --- In, "Nico Callewaert"
> wrote:
> >
> > 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
> > have the result set. When I open the query again, it takes only
> > seconds. After searching the newsgroups, I've found that this
> > performance issue is related to loading of metadata, triggers,
> > 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,
> 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
> 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
> hyperthreading.
> 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
> queries, but this will not take 30 seconds, maybe 1 or 2 for the
> connection.
> When is the delay? Is it really running the first query, or is it
> establishing the first connection or transaction etc.
> Adam
> > This problem only occurs after rebooting. So, is there a way I
> > 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
> >