Hi,

Had the same thing using IBObjects. It turned out the connetion read a
lot of metadata from the server the first time the application started.

IBObjects can use a cachedir to cache the meta-data. Switching it on
really improved startup speed, but you have to be aware to refresh that
cache as soon as metadata changes....

Don't know if FIBPlus can cache metadata...

hth!
John

Nico Callewaert wrote:

> Hi,
>
> Thanks for the info. The Firebird build is 1.5.2.4731. 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,
>
> Nico
>
> --- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> >
> > --- In firebird-support@yahoogroups.com, "Nico Callewaert"
> <ncw@p...>
> > 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
> 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
> > 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
> subsequent
> > queries, but this will not take 30 seconds, maybe 1 or 2 for the
> first
> > 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
> 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
> > >
> >
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw>
> Computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
> Compaq computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>
>
> Compaq technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
> Hewlett packard technical support
> <http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>
> Microsoft technical support
> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>