Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by esa001
-
Big one...
I'm using FireBird (InterBase like) with Delphi7 and IUIB component. Thx anyway. -
Big one...
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... :o) -
Big one...
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...
