MySQL Update - 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 Update (/showthread.php?tid=420288)
+- 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 Update (/showthread.php?tid=420288)
MySQL Update - Pille_ - 04.03.2013
Hi guys,
whats the best way to save a single row in a MySQL-database?
There are 109 rows to update (each Player, each account).
1. format a > 2500 string, concatenates the string with strcat, and send as a query?
2. Sending 5 Querys, with a length of ~500?
3. Or Sending 109 Querys, with a length of ~50?
I tried to do this in one query (1), with a 2500-big-string, but my Server has got a few
problems with it (crashdetect, see below).
Код:
[23:19:32] [debug] Run time error 3: "Stack/heap collision (insufficient stack size)" [23:19:32] [debug] Stack pointer (STK) is 0x30EFF8, heap pointer (HEA) is 0x30F6EC [23:19:32] [debug] AMX backtrace: [23:19:32] [debug] #0 ???????? in public JB_OnPlayerDisconnect () from lssf.amx [23:19:32] [debug] #1 native CallLocalFunction () [00471e90] from samp-server.exe [23:19:32] [debug] #2 ???????? in public Streamer_OnPlayerDisconnect () from lssf.amx [23:19:32] [debug] #3 native CallLocalFunction () [00471e90] from samp-server.exe [23:19:32] [debug] #4 ???????? in public OnPlayerDisconnect () from lssf.amx [23:19:32] [debug] #5 native Ban () [0046ef20] from samp-server.exe [23:19:32] [debug] #6 ???????? in public JB_OnPlayerCommandText () from lssf.amx [23:19:32] [debug] #7 native CallLocalFunction () [00471e90] from samp-server.exe [23:19:32] [debug] #8 ???????? in public OnPlayerCommandText () from lssf.amx
Re: MySQL Update - Vince - 04.03.2013
4. Don't put everything in a single table and only update stuff when it's needed.
AW: MySQL Update - Pille_ - 04.03.2013
I only save the player's Accounts every 10 Minute (sometimes the Server is crashing,
so data won't be lost) and every time a player goes offline.
What do you mean?
Should I create a table for each user?
Re: MySQL Update - Vince - 04.03.2013
No, but if you need a 2500 character long query then you clearly have too many fields (columns). I would set 30 fields as an absolute maximum for a table.
AW: MySQL Update - Pille_ - 04.03.2013
I'm sure that there are some fields which are a little bit useless,
but a huge script needs huge Information, that needs to be saved in Databases.
(I'm sorry if the grammar is fail)
What do you think should I do?
Create 2 databases, each has ~50 fields?
Re: MySQL Update - Misiur - 04.03.2013
s/databases/tables
OP, learn about table relationships, and foreign keys.
Re: AW: MySQL Update - mamorunl - 04.03.2013
Quote:
|
Originally Posted by Pille_
 I'm sure that there are some fields which are a little bit useless,
but a huge script needs huge Information, that needs to be saved in Databases. (I'm sorry if the grammar is fail) What do you think should I do? Create 2 databases, each has ~50 fields? |
AW: MySQL Update - Pille_ - 04.03.2013
Quote:
|
No, you should normalise your tables if you haven't done so already and set standard values. Also, there is probably stuff that you hardly update, so you can add that to the function itself (e.g. adminlevel). |