Subject Re: Slow execution of first query
Author Nico Callewaert
Hi Pavel,

The connection to the DB is fast, it's only the first time
the "Query.Open" statement is executed. The next 10 or 20 times I
open the query, it's always fast. I know this is not the right list
to ask, but is it possible with FIBPlus to load the metadata at
startup of the application ?

Thanks again !

Nico


--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@l...> wrote:
>
> Hello Nico,
>
> NC> Thanks for the info. The Firebird build is 1.5.2.4731. It is
> NC> running local on a Windows XP machine. DB connectivity is done
using
> NC> FIBPlus. The extension is FDB and no shadowing.
> NC> The delay is happening only when the first time the form is
opened.
> NC> The connection to the database is established already at that
point.
> NC> I will try the hyperthreading. Anything I can check still ?
>
> Can you trace, and tell us at which step it take too long: when you
> perform DB.Connect; when you perform Dataset/Query.Open...?
>
> And FIBPlus allows you caching of meta-data (as IBO does), so you
may
> use it.
>
>
>
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com
>