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

11000011010012 Posts
Default

Quote:
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