20.12.2014, 08:07
There are at least four limitations:
1. MySQL max allowed packet size http://dev.mysql.com/doc/refman/5.1/...too-large.html
2. http://dev.mysql.com/doc/refman/5.0/...eal-query.html (max unsigned long, so 4,294,967,295 - 1 bytes)
3. I'm not sure about this one, but unpacked strings (the default ones) are not char sized, but cell sized (so 4 bytes, not 1).
4. Your heap size (which in turn will make AMX gigantic [well, you could use y_malloc to do this at runtime though])
Are there better options? Yup, split your insert query into smaller chunks, and wrap it with a transaction to ensure that everything is saved only if all of the queries were successful.
1. MySQL max allowed packet size http://dev.mysql.com/doc/refman/5.1/...too-large.html
2. http://dev.mysql.com/doc/refman/5.0/...eal-query.html (max unsigned long, so 4,294,967,295 - 1 bytes)
3. I'm not sure about this one, but unpacked strings (the default ones) are not char sized, but cell sized (so 4 bytes, not 1).
4. Your heap size (which in turn will make AMX gigantic [well, you could use y_malloc to do this at runtime though])
Are there better options? Yup, split your insert query into smaller chunks, and wrap it with a transaction to ensure that everything is saved only if all of the queries were successful.