View Single Post
Old 2012-09-03, 16:59   #27
A Sunny Moo
mdettweiler's Avatar
Aug 2007

3·2,083 Posts

Originally Posted by CGKIII View Post
Similar request for info. I started my personal server with ~1000 k's at n = 2500, originally loaded with a bit over a million candidate tests. I've gotten it down to 500,000 due to a lot of messy SQL (and completing tests / finding primes), but it would be awesome to get some better code. Of course, next time I'll narrow things down a bit more first.
It turns out it's pretty simple: just run "optimize table table;" for each table in the database. (I'm assuming you already know the basics of getting in and navigating through an SQL database, since you were able to clean out old tests from your server.)
mdettweiler is offline   Reply With Quote