I have a database with an Auto increment field. I want to retrieve the value of the Auto increment column whenever i insert a record in database. I am using mysql as my database and PHP as my programming language. I tried using mysql_insert_id() function but then it is not suitable when there are large number of insertion taking place at same point of time.
I want to retrieve the value of AI column because i am storing a file for respective record and since i am storing the files in a single directory i need the file name to be unique. Any other way to do the same thing?