I am running a executemany() command that is too large for mysql to handle. I can increase the "max_allowed_packet" command in mysql, but I was wondering if there's a way to split the command into smaller queries at the client side. Does executemany have some sort of built-in function to split the query into smaller, more palateable queries for mysql?
Do I have to program this in? If so, how should I determine the size of the query that executemany() is about to perform?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am running a executemany() command that is too large for mysql to handle. I can increase the "max_allowed_packet" command in mysql, but I was wondering if there's a way to split the command into smaller queries at the client side. Does executemany have some sort of built-in function to split the query into smaller, more palateable queries for mysql?
Do I have to program this in? If so, how should I determine the size of the query that executemany() is about to perform?
It does not. Either split your argument list into smaller pieces or increase max_allowed_packet.