Mysql blueg r38 plugin limits - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql blueg r38 plugin limits (
/showthread.php?tid=551616)
Mysql blueg r38 plugin limits -
Banditukas - 20.12.2014
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?
Re: Mysql blueg r38 plugin limits -
Misiur - 20.12.2014
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.