Temporary table
Posted: Fri Oct 09, 2009 1:26 pm
Hello all,
I had a customer who is parsing many feed responses for each session of a user using curl_multi_handle methods. Some of the feeds are huge and they take time to response time as their xml files. I've split the curl calls to individual curl calls, and stored them in xml files. These xml files are parsed and used for search. Currently this is being done in arrays, which is what is creating problems, now
I would like to store it in temporary table. Somehow, I was thinking how mysql would use temporary tables for each session.
My Question is
1. If I create a temporary table, how will two concurrent sessions are going to use it, i.e. a user is doing search, at the same instance, and another user is doing search, for each search, will the temporary table created with a name, will it be same? if so can I attach, PHP session_id to the temp_table name and create temp tables accordingly.
If so, how do I do this on MySQL using create temporary table syntax, will MySQL allow such table names?
Thank You
I had a customer who is parsing many feed responses for each session of a user using curl_multi_handle methods. Some of the feeds are huge and they take time to response time as their xml files. I've split the curl calls to individual curl calls, and stored them in xml files. These xml files are parsed and used for search. Currently this is being done in arrays, which is what is creating problems, now
I would like to store it in temporary table. Somehow, I was thinking how mysql would use temporary tables for each session.
My Question is
1. If I create a temporary table, how will two concurrent sessions are going to use it, i.e. a user is doing search, at the same instance, and another user is doing search, for each search, will the temporary table created with a name, will it be same? if so can I attach, PHP session_id to the temp_table name and create temp tables accordingly.
If so, how do I do this on MySQL using create temporary table syntax, will MySQL allow such table names?
Thank You