Hi
I'm experiencing the same type of problem.
Just as a add on, I've tested this with various tables, with different sizes, and different indexes.
It takes the application as well over a minute to open a table with 3 records in it, and when the application starts up the second time, it is lightning fast. The smallest PC i'm running it on is XP, 3.2 Gigahertz, 512 meg ram.

Thank you
Johan Fourie

-----Original Message-----
From: firebird-support@yahoogroups.com on behalf of menjit_singh
Sent: Fri 12/23/2005 10:35 AM
To: firebird-support@yahoogroups.com
Cc:
Subject: [firebird-support] Re: Slow 1st query



hello all,

i have found another person with the same problem as mine. Please read
message 29255 by Marcus on 31 Aug 2003. I experince the same problem,
high disk activity after reboot, slow qeury about (1.5 minutes) for
small db of about ~50 mb. I have turn of evrything, antivirus, XP
restore, change file extension and still nothing.

The biggest puzzle is why after the reboot, the first time i launch my
app and start the first query, it is so slow?

after 1.5 minutes of waiting (when 1st qeury done), then things start
to get really fast. When i restart the app (not the pc) respond is very
fast. it is slow for the 1st qeury after reboot. it only happen after
reboot. i used win 2000 pro, win xp home, pro, still the same problem.

Please help...

Thanks.
Menjit.






------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links