first tests are promising. adding a 2000 book single collection now works where it used to fail previously.
going to try with 4000+ books and 100+ collections now.
Update:
and it did not work. The kindle rebooted after printing
Code:
231221:074522 system: I LibrarianSync:cc_update:: Sending commands...
tail: /var/log/messages has been replaced; following end of new file
231221:074645 system: E LibrarianSync:main:: Something went very wrong.
might be too many SQL commands to process at a go. I'll try sending 10 SQL commands at a time and see if that works better..
UPDATE: doing the SQL commands in batches of 100 and it seems to be working so far.
and it succeeded.. but the collections in the kindle don't have the right number of entries.. will need to dig into the SQL being sent and see where I messed up.. probably need to change the "INSERT" into "UPDATE" for the items that were broken into multiple SQL commands..
the code I am using is here btw. if anyone wants to try it.
made changes at line 117 in cc_update.py (to split up the number of SQL commands sent in each POST message)
and at line 237 in generate_collections.py (to break up the items in each SQL command). added debugging output to see the books being added as well.