• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Plugin] Best Practices for MySQL Native Functions?
#2
Finally, after some research I found some answers:
  1. What will I get? or faster ? · Issue #83 · pBlueG/SA-MP-MySQL (github.com)
  2. mysql_pquery vs mysql_tquery (blast.hk)

Conclusion from references:
  • Use mysql_pquery to load a lot of data concurrently, mysql_tquery for everything else.

I think I'll change all of my mysql_query code to mysql_tquery or mysql_pquery depending on the needs, if I don't need the result ASAP better use mysql_tquery, and let it enter the queue. Otherwise, I'll use mysql_pquery to force it into the queue and get the result faster.

Its possible my mysqld is consuming more RAM because I forgot to clear some cache, but I'm pretty sure I already cleaedr the cache after running mysql_query.
I'll test it and update this thread later.

Let me know if you have other options or feedback for me!
  Reply


Messages In This Thread
RE: Best Practices for MySQL Native Functions? - by dr.iyz - 2024-02-12, 05:00 PM

Forum Jump: