I have a message board app I'm using where I'm trying to make the code faster and more efficient than it is now. At times this board will generate a lot of new posts to it very very quickly. In one section where posts are added, after the post is made and inserted into mysql, we need to get the post number, which is an auto-increment field, for the insert just finished. And then we need to use this to update the boards table with stuff like last post and then maybe send an email with a link in it, etc.. I found the last_insert_id section and it looks like this is what I want, where after I do the insert, I can do something like mysql> SELECT LAST_INSERT_ID();
My questions are: If I have something like 500 concurrent users is this a safe and reliable way to get that info if 50 of them are posting at the same time? Is there anything that would prevent the select from getting the last id that I need to watch for such as finish statements, etc... What version did this feature start in so I can make sure we can use it. Thanks in advance for any assistance. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
