Batch processing

[sarahk]

I'm running MySql 3.23.31 on my dev machine and 3.23.54 on production (hosted).

At various times I have needed to batch process and have had no problems with queries which are infact multiple inserts for example.

I'm creating a data intensive form and I want to be able to batch process the results of the form. I have a class which builds up a big string which I'm then passing to mysql. I'm using @ to process it.

However!

I'm getting "Unable to perform the query" whenever there is more than one statement. I'm finishing each statement with a semicolon.

Any ideas or do I abandon batch processing?

[tasistro]

maybe a loop with individual queries would do best. To do the batch stuff I've created files and the issue the command source filename.here. On a web environment it is a very bad idea to make a file and then source it to mysql so I'd stick with a loop.

[dbchip2000]

It would be easy to do a loop, just do something like exploding the batch query by the semicolon sign. Then you could loop through that using the mysql_query(trim(array value)) functions. But, then is there really a difference in inserting them when you would add it to the batch query?

[sarahk]

Hi Guys

thanks for the comments. My loop is creating the batch so it's really easy to break it down again. I was just trying to limit the number of hits to the database.

Sarah