2024-02-12, 05:00 PM
Finally, after some research I found some answers:
Conclusion from references:
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!
- What will I get? or faster ? · Issue #83 · pBlueG/SA-MP-MySQL (github.com)
- 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!