![]() |
|
|
#34 | |
|
May 2007
Kansas; USA
33×5×7×11 Posts |
Quote:
But...after much effort to figure out how to write this to a file and then give myself permissions to the MySQL folder, I've run the query. For the testing of k=2000-2050 on version 3.1.4, it selected 186993 rows. The full size file is 9.2 MB. Tarred up, it is 1.9 MB. Since it is too big to post here, I'm posting a file that includes only k=2001-2003 tests. If you need the full file, let me know how you'd like it sent to you. Last fiddled with by gd_barnes on 2010-01-27 at 12:09 |
|
|
|
|
|
|
#35 | |
|
May 2007
Kansas; USA
289B16 Posts |
Quote:
![]() ![]() And no more "lol"'s please. It's not funny anymore. Last fiddled with by gd_barnes on 2010-01-27 at 12:11 |
|
|
|
|
|
|
#36 | |
|
"Mark"
Apr 2003
Between here and the
11×577 Posts |
Quote:
The debuglevel setting is the last line of the prpserver.ini file. You can load the database by either having a prpserver.candidates file and using the upgrade command line option or using prpadmin and an ABC file. Large ABC files tend will take a while to load through prpadmin. |
|
|
|
|
|
|
#37 | |
|
A Sunny Moo
Aug 2007
USA (GMT-5)
3·2,083 Posts |
Quote:
Okay, okay, I'll do it...right now! ![]() BTW, if you check the server's web page, you'll notice that even though all those pairs are listed, they're listed as complete. I'm not sure if there's any way to clean them out eventually; Mark? |
|
|
|
|
|
|
#38 |
|
A Sunny Moo
Aug 2007
USA (GMT-5)
3·2,083 Posts |
Okay, I tried it again and...great, another compile error.
Looks like it will have to wait a bit longer. I've emailed Mark about the error.Gary, as I said in the note on humpford's desktop, I will be out of the house for much of today. I will nonetheless try to get to this when I get back, though I won't make any promises.
|
|
|
|
|
|
#39 | |
|
"Mark"
Apr 2003
Between here and the
18CB16 Posts |
Quote:
Eventually I will write a routine to remove candidates that need no further testing, but I don't know the best way to go about it. For example, do I wait a certain number of days after the test before removing it? Do I copy that data to another table instead of deleting it? Do I dump it to a file then delete it? I'm open to any ideas anyone has. |
|
|
|
|
|
|
#40 | |
|
"Lennart"
Jun 2007
25×5×7 Posts |
Quote:
Lennart. |
|
|
|
|
|
|
#41 | |
|
Account Deleted
"Tim Sorbera"
Aug 2006
San Antonio, TX USA
17×251 Posts |
Quote:
|
|
|
|
|
|
|
#42 | |
|
A Sunny Moo
Aug 2007
USA (GMT-5)
141518 Posts |
Quote:
|
|
|
|
|
|
|
#43 | |
|
"Mark"
Apr 2003
Between here and the
18CB16 Posts |
Quote:
This is something along the lines of what I have thought of (previously) combined with what is being stated here, both done through prpadmin. 1) Allow delete by form. For example, specify 12*199^n+1 for some servers would delete all candidates and tests for numbers where k = 12, b = 199 and c = 1. The form would be dependent upon the servertype. 2) Allow delete by timestamp. For example, ask user the age criteria for deleting candidates and tests. prpadmin would ask for a number of days. The server would then delete all candidates with double-checks that are older than that number of days. One exception would be that the server would not delete the candidates and their tests if any tests/double-checks older than that are still pending. For example, if you want to delete everything older than 2 days, but there is a incomplete test from 3 days ago, then nothing would be deleted. This could be controlled by form. For a FixedKBC server, this would mean that an old outstanding test for k=111999 would not prevent the deleting of candidates for k=112001. Thoughts? |
|
|
|
|
|
|
#44 |
|
Just call me Henry
"David"
Sep 2007
Cambridge (GMT/BST)
23·3·5·72 Posts |
|
|
|
|
![]() |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LLRnet and PRPnet servers for automated LLR | mdettweiler | Twin Prime Search | 235 | 2021-05-13 21:13 |
| LLRnet/PRPnet rally April 4th-11th | mdettweiler | No Prime Left Behind | 55 | 2011-04-25 09:35 |
| LLRnet/PRPnet rally January 3rd-10th | mdettweiler | No Prime Left Behind | 48 | 2011-01-12 10:14 |
| LLRnet/PRPnet rally Oct. 27th-Nov. 3rd | mdettweiler | No Prime Left Behind | 33 | 2010-12-24 19:16 |
| LLRnet/PRPnet rally June 4th-6th | gd_barnes | No Prime Left Behind | 61 | 2010-07-30 17:28 |