Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Need advice on buffer sizes
08-15-2006, 05:54 PM #1
- Join Date
- Jan 2005
- Thanked 0 Times in 0 Posts
Need advice on buffer sizes
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.