open.mp forum   ›   SA-MP   ›   Pawn Scripting   ›   [Pawn] QUESTION about MYSQL

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Pawn] QUESTION about MYSQL
redex
Burgershot Member
Joined: May 2021
Posts: 10

Reputation: 0

Location: Germany
#1
2021-06-05, 11:35 AM
hi , i was wonder which one is better to use for getting player data from database when he logged-in , i have about user in my data base and i have to select user from this amount of users , currently i use something like this :



pInfo[playerid][score] = mysql_get ...

pInfo[playerid][skinid] = mysql_get ...

pInfo[playerid][money] = mysql_get ...



i mean i have 1 query per item! and i think this will make server LAG , should i get all items in a SELECT * query and then put them in variables? does it make any diffrent to avoid lag ? sorry i know my english is AWFUL but i guess i made my point!
  Reply
Radical
Burgershot Member
Joined: Dec 2020
Posts: 176

Reputation: 17
#2
2021-06-05, 12:39 PM (This post was last modified: 2021-06-05, 12:42 PM by Radical.)
One query for per item makes lag.
Get all in one query.

(2021-06-05, 11:35 AM)redex Wrote: does it make any diffrent to avoid lag?
Yes.

Also upgrade to the latest version of MySQL (r41-4) if you are still using the older version.
  Reply
redex
Burgershot Member
Joined: May 2021
Posts: 10

Reputation: 0

Location: Germany
#3
2021-06-05, 01:06 PM
(2021-06-05, 12:39 PM)Radical Wrote: One query for per item makes lag.

Get all in one query.



and if i am not wrong its just related to select right? i mean only select have cache i dont use cache in others (like insert, delete or ...) so on that cases it will not make such a lag right? i mean its a little bit to hard to save the account in one query, i do the saving on player disconnect and all his stats will save there and there are a lot items that need to be saved, so its hard to put them all in one single query
  Reply


Forum Jump: