Query and string size. - 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: Query and string size. (/showthread.php?tid=549507)

---

Query and string size. - Banditukas - 07.12.2014

Hi,

I want to ask.

Is there any difference if i do mysql query and use string a very big? i mean it'is will call for query in speed?

---

Re: Query and string size. - Lordzy - 07.12.2014

No, you shouldn't use larger cell size. It will eat your memory and reduce performance while execution. Use the sufficient amount of cell size depending on your query string's length.

forum.sa-mp.com/showthread.php?t=55261 - This topic is in regarding not using 256 cells unnecessarily, which you might want to read.

---

Re: Query and string size. - Banditukas - 07.12.2014

But when i'am saving i need about 5000 cells, because i save a lot and impossible to make less.

---

Re: Query and string size. - Vince - 07.12.2014

*sigh*

Of course it is possible to make less! You don't need to save ALL data ALL the time. Save the data you need, when you need to, and leave the rest untouched. It probably also means that your tables are poorly structured and poorly optimized. I've written large SQL procedures for my SQL examination that don't even go over 1000 characters, so you needing more than 5000 is really rather strange.

---

Re: Query and string size. - Banditukas - 07.12.2014

I save when player disconnect when i can save in other time? in commands or other way player can spam it.

---