Loading partial database

• jon pill

  SSCommitted

  Points: 1599

  More actions

  May 21, 2010 at 3:55 am

  #221426

  Apart from an early morning run where I query the whole databases in time steps/increments, I then only query that last 10-15mins of a database that is about 300,000 rows.

  How can i manage the database when I only want the last 10,000 rows in the RAM. And separate that from a wider search?

  Thanks

  Neil

• Stefan_G

  SSCertifiable

  Points: 6609

  More actions

  May 21, 2010 at 5:29 am

  #1170726

  Just make sure you do not perform any table scans after the morning run. Data that you dont read will never be loaded into RAM.

  The data that you loaded in the morning will be pushed out of RAM if RAM is needed to store recently read data.

  In short: this is not a problem that you need to think very much about.