Subject | Slow execution of first query |
---|---|
Author | Nico Callewaert |
Post date | 2005-11-23T10:38:50Z |
Hi all,
I'm having a performance problem. After powering up the computer and I
execute a certain query the first time, it takes about 30 seconds to
have the result set. When I open the query again, it takes only 3
seconds. After searching the newsgroups, I've found that this
performance issue is related to loading of metadata, triggers, SP,
etc...
This problem only occurs after rebooting. So, is there a way I can
force to load all of that stuff at startup time of the application ?
So, I can have a good speed all the time.
Thanks a lot in advance,
Nico Callewaert
I'm having a performance problem. After powering up the computer and I
execute a certain query the first time, it takes about 30 seconds to
have the result set. When I open the query again, it takes only 3
seconds. After searching the newsgroups, I've found that this
performance issue is related to loading of metadata, triggers, SP,
etc...
This problem only occurs after rebooting. So, is there a way I can
force to load all of that stuff at startup time of the application ?
So, I can have a good speed all the time.
Thanks a lot in advance,
Nico Callewaert