Mysql tquery/pquery - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql tquery/pquery (/showthread.php?tid=532960)

---

Mysql tquery/pquery - Banditukas - 21.08.2014

Hi,

I want to ask.

I i use a lot of mysql_connect, i mean not a lot of, but in my web show something from server or another stuff. It'is somehow increasing my queries in server? because i don't very understand different between mysql_tquery and mysql_pquery. Where is mysql_pquery there is writing that it will be faster until how much mysql connections will be, but it don't take transations.

---

Re: Mysql tquery/pquery - Misiur - 21.08.2014

You have to use only single mysql_connect, mysql_pquery will take care of opening new connections.

Here's the explanation of the diffrence - http://forum.sa-mp.com/showpost.php?...postcount=5021

---

Re: Mysql tquery/pquery - Banditukas - 21.08.2014

It means that mysql_pquery there execution can be random, from random querie, mysql_tquery if you send a querie, and another queries first complete first querie and then other in a row

---

Re: Mysql tquery/pquery - Misiur - 21.08.2014

Exactly. That's why you can't use transactions with pquery, but can with tquery.

Singluar of "queries" is "query".

---