Burgershot
  • Home
  • Members
  • Team
  • Help
  • Search
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Burgershot SA-MP Support [Server] MySQL Query ~ Which one is the most efficiency?

 
  • 0 Vote(s) - 0 Average
Server MySQL Query ~ Which one is the most efficiency?
LinesinRows
Offline

Burgershot Member
Posts: 13
Threads: 4
Joined: Feb 2020
Reputation: 0
Location: Turkey
#1
2021-01-19, 12:57 PM
Code:
"UPDATE `players` SET q = %d, w= %d, e = %d, r = %d, t = %d, y = %d, u = %d, o = %d, a = %d, s = %d WHERE userid = %d", q, w, e...
mysql_tquery(blabla);

vs

"UPDATE `players` SET q = %d, w = %d, e = %d, r = %d, t = %d WHERE userid = %d", q, w, e...
mysql_tquery(blabla);
"UPDATE `players` SET y= %d, u = %d, o = %d, a = %d, s = %d WHERE userid = %d", y, u, o...
mysql_tquery(blabla);

  Which one and why? 
  Thanks for now.
« Next Oldest | Next Newest »



Messages In This Thread
MySQL Query ~ Which one is the most efficiency? - by LinesinRows - 2021-01-19, 12:57 PM
RE: MySQL Query ~ Which one is the most efficiency? - by Pinch - 2021-01-19, 06:33 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