Subject Re: Slow 1st query
Author Adam
--- In firebird-support@yahoogroups.com, "menjit_singh"
<menjit_singh@y...> wrote:
>
> hello,
>
> i have done it (.gdb>.fdb) and also turn off antivirus. still same
> problem
>

ok, just read all the posts relating to this.

What you need to do is to work out what is taking up all the time? Is
it the connection or the query etc.

It may be something to do with your program rather than Firebird, so
that is a good place to start. Open up iSQL and connect to the
embedded database, and run a simple query.

SELECT FIRST 1 STOCK FROM DATA

This should be really fast (subsecond). I suppose if it is the first
query by the database it may take a few seconds, but definately not
minutes.

If it is instant, then you can try it again using the initial query
you run from your program. You can then know whether you have an
issue with Firebird or an issue with your Firebird connection
components.

Adam