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

Thread: pre-cache tables

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    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.

    Thanks.

  2. #2
    Join Date
    Feb 2001
    Posts
    290
    are you doing the flusing the shared pool ??
    Madhu Reddy
    xdollor@yahoo.com

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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