Team drive #13: k=400-600 n=1M-2M - Page 3

mdettweiler · 2012-09-02, 15:55

Quote:

Originally Posted by AMDave

I just optimized the database tables for that port now the range is removed.
should be a touch quicker.

Excellent, thanks! (Wow, it loads fast--I just pulled up http://noprimeleftbehind.net:9000/all.html in half a second flat!

)

BTW, how does one go about optimizing the tables (what commands, etc.)? You've probably told me before but I can't recall it for the life of me...

AMDave · 2012-09-02, 20:09

email sent

henryzz · 2012-09-02, 21:11

Quote:

Originally Posted by AMDave

email sent

I am afraid max isn't the only one interested. Am I right in thinking that optimising the tables after adding a rediculous amount of candidates is just as helpful as doing it after deleting them? I created a server recently with too many candidates and it took ages to respond to the client.

CGKIII · 2012-09-03, 05:50

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.

mdettweiler · 2012-09-03, 16:59

Quote:

Originally Posted by CGKIII

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.)

henryzz · 2012-09-18, 10:24

Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?

kar_bon · 2012-09-18, 11:13

Quote:

Originally Posted by henryzz

Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?

Because there's more activity on Drive 14 (Port 2000) than on Drive 13 (Port 9000):

the last days there were ~300 paris done on Port 2000 but only ~30 on Port 9000.
End of August the difference in pairs was much higher.

gd_barnes · 2012-09-18, 18:18

Quote:

Originally Posted by henryzz

Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?

We had two rallies on drive 14 when it was behind drive 13. Then a big cruncher stayed on drive 14 for a long time afterwords. Our next rally will be on drive 13.

gd_barnes · 2012-09-22, 07:25

Reserving n=1160K-1200K for port 9000.

gd_barnes · 2013-03-30, 18:59

I seem to be searching all the primeless ranges on this drive so that everyone else can find the primes.

There's been one prime in the last n=23K range; by far the worst range since the drive started. I wonder if all of my machines have gone bad at once.

MyDogBuster · 2013-03-30, 19:43

Quote:

There's been one prime in the last n=23K range; by far the worst range since the drive started.

Probably setting up for a nice run shortly.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Team drive #6 k=600-800 n=600K-1M	gd_barnes	No Prime Left Behind	89	2011-03-10 12:34
Team drive #5: k=400-600 n=600K-1M	gd_barnes	No Prime Left Behind	135	2010-11-23 14:27
Team drive #4, 15 k's < 300 for n=600K-1M	gd_barnes	No Prime Left Behind	38	2008-10-22 16:20
Opinions on team drive #3	gd_barnes	Conjectures 'R Us	8	2008-01-24 01:01
Don't Miss The First RPS Team Drive!	Kosmaj	Riesel Prime Search	451	2007-07-08 21:06

2012-09-02, 20:09	#24
AMDave Jan 2006 deep in a while-loop 2×7×47 Posts	email sent

2012-09-03, 05:50	#26
CGKIII Aug 2012 5² Posts	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.

2012-09-18, 10:24	#28
henryzz Just call me Henry "David" Sep 2007 Cambridge (GMT/BST) 2³·3·5·7² Posts	Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?

2012-09-22, 07:25	#31
gd_barnes May 2007 Kansas; USA 24233₈ Posts	Reserving n=1160K-1200K for port 9000.

2013-03-30, 18:59	#32
gd_barnes May 2007 Kansas; USA 10100010011011₂ Posts	I seem to be searching all the primeless ranges on this drive so that everyone else can find the primes. There's been one prime in the last n=23K range; by far the worst range since the drive started. I wonder if all of my machines have gone bad at once.