How do I know if db->query_write is reusing a SQL connection ?

[mihai11]

Originally Posted by Dismounted

vBulletin only opens one connection per page and uses that until the end of execution. (Different if you turned on persistent connections in config.php.)

So, if I call in a for loop the function query_write 1000 times then it will use the same connection, right ?

How can I be sure about this ? Is there a tool on mysql side to check how many connection were created ? (like a log file for connections)

One more thing: what about persistent connections ? I assume that you are talking about this:

	//	****** MASTER DATABASE PERSISTENT CONNECTIONS ******
	//	This option allows you to turn persistent connections to MySQL on or off.
	//	The difference in performance is negligible for all but the largest boards.
	//	If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;

What if I enable persistent connections ? What is changing in this case ?



Regards,
Razvan