View Full Version : Need advice on buffer sizes

08-15-2006, 05:54 PM
I have a table that is over 400 MB in size and has about 150,000 records. Queries are getting steadily slower as the table grows which is slowing the site down.

The server itself has 4 GB of RAM available to it.

Anyone have any suggestions for setting the following variables?

I have heard that larger sizes on these is not always better and can even slow the queries down so I am trying for figure out what would be the best values based upon this very large table as it takes the bulk of the queries from the site.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum