Burgershot
  • Home
  • Members
  • Team
  • Help
  • Search
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Burgershot SA-MP Pawn Scripting [Pawn] QUESTION about MYSQL

 
  • 0 Vote(s) - 0 Average
Pawn QUESTION about MYSQL
redex
Offline

Burgershot Member
Posts: 10
Threads: 5
Joined: May 2021
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 +4k 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!
« Next Oldest | Next Newest »



Messages In This Thread
QUESTION about MYSQL - by redex - 2021-06-05, 11:35 AM
RE: QUESTION about MYSQL - by Radical - 2021-06-05, 12:39 PM
RE: QUESTION about MYSQL - by redex - 2021-06-05, 01:06 PM

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Burgershot - Powered by our Community and MyBB Original Theme by Emerald

Linear Mode
Threaded Mode