> My machines can only hold 12Gig of RAM but the database will 
> quickly grow to 100's of Gigs.
> But yes, I plan on filling it with RAM as soon as possible.
> 
> Are there any particular settings to keep certain tables or indexes in
> memory so they don't get dropped from cache?

Resident tables? No. 
But if you need the index/table often, then the odds are high that it's already 
in the cache when you need it.

> Generally the queries return less than 500 result records of 
> 5-15 fields,
> mostly text. The queries are usually joins of tables with millions of
> records.

Make sure that you have indexes that support your WHERE clause and the join 
condition. At best the WHERE clause for the leading table returns only few rows.

Best regards
Christian
-- 
#include <std_disclaimer.h>
/* The opinions stated above are my own and not
   necessarily those of my employer. */


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to