Quote:
Originally Posted by sorrow
ES - Did you run a bulk import of any sort? We would see the performance improvements if any, much more clearly there.
I'm doing this now, as it happens, as I've had to re-create my database. The improvement is quite significant.
The import speeds for INNODB are:
Total stored: 50 duplicates: 0 partial: 0 errors: 0 time: 3.12080478668
Total stored: 62 duplicates: 0 partial: 0 errors: 0 time: 3.21394014359
Total stored: 29 duplicates: 0 partial: 0 errors: 0 time: 1.57156395912
Total stored: 42 duplicates: 0 partial: 0 errors: 0 time: 2.02770709991
Total stored: 25 duplicates: 0 partial: 0 errors: 0 time: 1.35693788528
Total stored: 82 duplicates: 0 partial: 0 errors: 0 time: 4.49442195892
And for MyISAM, working on the same files:
Total stored: 50 duplicates: 0 partial: 0 errors: 0 time: 2.44788789749
Total stored: 62 duplicates: 0 partial: 0 errors: 0 time: 2.25488519669
Total stored: 29 duplicates: 0 partial: 0 errors: 0 time: 1.0653860569
Total stored: 42 duplicates: 0 partial: 0 errors: 0 time: 1.45321798325
Total stored: 25 duplicates: 0 partial: 0 errors: 0 time: 0.952408075333
Total stored: 82 duplicates: 0 partial: 0 errors: 0 time: 2.91316795349
I wasn't planning to do a comparison, but after deleting my old database I forgot to convert the new one to MyISAM. The second set of figures show what happened when I deleted the database once again, converted it to MyISAM, and then started re-importing.
P.S. Curiouser and curiouser! I'm about to send Steffen an error report, as this has just happened:
Code:
len(bets)>2 in convert3B4B, i didnt think this is possible. i: 2 j: 4 k: 3
actionTypes: [[['blind', 'call'], ['fold'], ['fold'], ['fold'], ['bet'], ['blind', 'call']], [['fold'], [], [], [], ['call'], ['bet']], [[], [], [], [], ['bet', 'bet', 'bet', 'bet'], ['bet', 'bet', 'bet', 'bet', 'call']], [[], [], [], [], [], []]]
Error No. 1 , please send the hand causing this to steffen@sycamoretest.info so I can fix it.
Filename: [...]
Here is the first line so you can identify it. Please mention that the error was a ValueError: [...]
When the bulk importer has finished I'll see if I can find out what went wrong here (it's happened twice now).