Thanks to everybody for the replies !

Nico

--- In firebird-support@yahoogroups.com, John vd Waeter <john@j...>
wrote:

>
> 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+su
pport&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+tec
hnical+support&w3=Compaq+computer+technical+support&w4=Compaq+technica
l+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=Compu
ter+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+t
echnical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+tec
hnical+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+techn
ical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+
support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+su
pport&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=Compu
ter+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+t
echnical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+tec
hnical+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+te
chnical+support&w3=Compaq+computer+technical+support&w4=Compaq+technic
al+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/>.
> >
> >
> > ------------------------------------------------------------------

------

> >
>