[Banditukas]

Hi,

I want to ask. This plugin have any limits in query lenght? because i imagine you can't to update 1 million values or something simillar. Or this limits is in mysql server?

[Misiur]

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.