In my PHP Yii2 project, I am calling a MySQL Stored Procedure that creates a temporary table among other things and takes about 3-4 seconds to complete.
Does Yii2 reuse the same database connection for all users or does it create a new one, every time a user visits the website? I understand that the temporary tables are relative to a connection.
So, if I have 50+ users at the same time using the feature that calls the procedure, then is there a chance that all the procedures try to use the same temp table?