[Resolved] CREATE + INSERT 1-liner to MySQL via PHP...possible?

s_shrum

I have a script that creates a table and populates it with a bunch of records. I'm trying to cut down the number of MySQL calls as my host provider is complaining that my script is using more CPU resources than all the other sites combined on the server :p

I want to know if I can pass 2 SQL calls via a 1-liner seperated with ";" - a create and insert string...sorta like this:

"Create table BLAH (fields here);Insert into BLAH (fields) values (recorddata1), (recorddata2), ..., (recorddatan-1), (recorddatan);"

Does anyone know if this sort of SQL sting is supported AND (better yet if it does work) does anyone know if this sort of call would take more or less CPU cycles to process?

TIA

Sean Shrum
http://www.shrum.net

tasistro

Do you have indexes? How well are they working? How big are the results from your SQLs? Are you using LIMIT?

I believe these issues are more at hand in solving your problem.

s_shrum

Figured it out: MySQL doesn't like to process anything past the first ";" in the string and therefore errors out on the rest of the string.

I had to break it up into 2 parts: $create_sql and $populate_sql and proces them in 2 queries.

Thanks anyways.

Sean Shrum
http://www.shrum.net