Subject | Re: [firebird-support] Re: Slow execution of first query |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-11-24T08:47:17Z |
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
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