Subject | Re: Slow 1st query |
---|---|
Author | Adam |
Post date | 2005-12-21T05:52:26Z |
--- In firebird-support@yahoogroups.com, "menjit_singh"
<menjit_singh@y...> wrote:
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
<menjit_singh@y...> wrote:
>ok, just read all the posts relating to this.
> hello,
>
> i have done it (.gdb>.fdb) and also turn off antivirus. still same
> problem
>
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