MySQL 40 - (p/t)query.
#5

Quote:
Originally Posted by IstuntmanI
Посмотреть сообщение
Yes, but mysql_tquery itself runs on another thread, so if you send a huge query it won't block server's thread like mysql_query does, it will still have one queue (well, mysql_query has no queue at all, it is "instant"), so if you send a huge query then a small query, the small query will be executed really late because the huge query is still being executed, but at least the main server thread won't be locked for a while (like mysql_query does). For multiple threads/queues you need to use parallel query.

I'd suggest to use mysql_pquery as much as possible, with at least a pool size of 4 (4 queues/connections for the mysql_pquery function). It will be fine as long as you don't think that it gets executed in order. Keep in mind that.
Alright, thank you.
Reply


Messages In This Thread
MySQL 40 - (p/t)query. - by Meller - 17.11.2017, 20:13
Re: MySQL 40 - (p/t)query. - by IstuntmanI - 17.11.2017, 20:25
Re: MySQL 40 - (p/t)query. - by Meller - 17.11.2017, 20:29
Re: MySQL 40 - (p/t)query. - by IstuntmanI - 17.11.2017, 20:35
Re: MySQL 40 - (p/t)query. - by Meller - 17.11.2017, 20:37
Re: MySQL 40 - (p/t)query. - by wallee - 18.11.2017, 01:33
Re: MySQL 40 - (p/t)query. - by IstuntmanI - 18.11.2017, 14:16
Re: MySQL 40 - (p/t)query. - by wallee - 18.11.2017, 15:40

Forum Jump:


Users browsing this thread: 1 Guest(s)