> 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]