Big one...

[esa001]

Hi all,
I just have a question for you :

the first time I make a query to my big (over 2 M records) DB on the ID field (indexed), I've to wait for more than 1 minute.
The next queries take less than 200 ms.

Can I force SQL to use some system cache or need I still make a 1st query when application is mounting?

Thx.

 

[Cagliostro]

I think you could create an index on your query. For example in Oracle you can use create index idxname...

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com

 

[esa001]

The ID index is already created and used. It seems SQL needs a first query to use memory cache. Other next same queries are quick.
It's why I do a 1st query during launching my NT service then users dont do the 1st slow one. But I'm unhappy cuz my service mount within more than 1 minute... )

 

[Cagliostro]

I think the first query activates some OnFirstRequestActivate like objects. Would be better you to put your question in oracle forums if you use Oracle:
forum186

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com

 

[esa001]

I'm using FireBird (InterBase like) with Delphi7 and IUIB component.

Thx anyway.