Query and string size.
#1

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?
Reply
#2

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.
Reply
#3

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

*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.
Reply
#5

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


Forum Jump:


Users browsing this thread: 1 Guest(s)