Sean,

The database is on the local hard drive.
The query returns 4,000 rows each of which is pretty wide, so there is a lot
of I/O involved. The query itself is pretty simple and just selects from a
single table while filtering on an indexed field.

What setting should I consider changing in firebird.conf in order to make a
query like this faster?

Thanks,

Alec

On Thu, Nov 19, 2009 at 3:45 PM, Leyne, Sean <Sean@...>wrote:

>
>
> Alec,
>
>
> > Our users complain that it takes 30 seconds to execute a query right
> > after the machine comes back from hibernation. The following
> > executions of the same query take 4 seconds. Is there a way to speed
> > up the first query execution right after hibernation?
>
> Hibernation is a bit of an "odd duck". In theory, the data which is in the
> Windows cache should be maintained when the system resumes but it may be the
> case that Windows is flushing the cache.
>
> To be clear, the database is stored on the local HDD, right?
>
> Separately, I would be interested in the query and it's statistics, it is
> possible that it could be optimized to reduce the execution speed. By doing
> that, reducing the number of disk reads, which could improve the
> post-hibernation performance. 4 seconds is a little on the "long side".
>
> Sean
>
>
>


[Non-text portions of this message have been removed]