From: Girish Talluru Date: November 23 2012 5:19am Subject: Stored Procedure Question? List-Archive: http://lists.mysql.com/mysql/228708 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d044630a0d9db5104cf22bbd8 --f46d044630a0d9db5104cf22bbd8 Content-Type: text/plain; charset=ISO-8859-1 Hi There, I have a scenario where I have to screen a huge bunch of records for in db using certain rules. I have done in traditional php style record by record and it took 90 mins for 4000 records. I have 800k - 900k records in production which might possibly lead to days of execution. I have figured out that the php script does wait for the record to execute and then only after it it will process the next record. For this if it is java I should have used stored procedure and multithreading concept to run multiple threads in parallel. But I don't think PHP supports multithreading. Now I have idea to create a stored procedure to do all the checks and my question here is when I call a stored procedure does the control get backs immediately to the php script? Bcoz I want to pick other record immediately while the first one going through the process and call the procedure again. Thanks, Girish Talluru --f46d044630a0d9db5104cf22bbd8--