BrianPap22
asked on
Persistent Connections & LAST_INSERT_ID (LAMP)
MySQL 5.0.27
PHP 5.2.0
Apache 2.0.59
I'm running a LAMP server and am thinking of testing out persistent connections to improve performance during peak load (several hundred users per minute). The issue is that there are several different pages in my website that insert a record to an auto_increment table, then next issue a simple "SELECT LAST_INSERT_ID()" query. When using persistent connections, do I ever have to worry about one user getting the last_insert_id of another user in a race situation? Is there certain coding I need to do in my PHP code to avoid this?
I've received conflicting answers to this question, so I would appreciate a little more than a simple Yes/No answer.
Thank you,
-Brian
PHP 5.2.0
Apache 2.0.59
I'm running a LAMP server and am thinking of testing out persistent connections to improve performance during peak load (several hundred users per minute). The issue is that there are several different pages in my website that insert a record to an auto_increment table, then next issue a simple "SELECT LAST_INSERT_ID()" query. When using persistent connections, do I ever have to worry about one user getting the last_insert_id of another user in a race situation? Is there certain coding I need to do in my PHP code to avoid this?
I've received conflicting answers to this question, so I would appreciate a little more than a simple Yes/No answer.
Thank you,
-Brian
Aamir Saeed
to avoid conflictions, try LAST_INSERT_ID() with user_id.
ASKER
I don't understand what user_id is.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.