pre-cache tables Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: pre-cache tables

  1. #1
    Join Date
    Sep 2001
    Is there a way to cache tables or row cache tables into memory at database startup time? The reason I want to do this is because when the database first starts up, some queries take a long time to execute, but subsequent executions of the queries are faster (even if the selection criteria has changed). I've analyzed the timings of the query and the parsing time is minimal compared to the execution/fetch times.


  2. #2
    Join Date
    Feb 2001
    are you doing the flusing the shared pool ??
    Madhu Reddy

  3. #3
    Join Date
    Nov 2000
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width