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.