Skip to main content
Participant
July 31, 2008
Question

mysql: singly or all at once?

  • July 31, 2008
  • 2 replies
  • 413 views
I have a long form which is done all in Flash. The flash form POSTs to php, which then does an INSERT into mysql.

I'm wondering if I should instead do a series of inserts as each question is completed, rather than all at once at the end?

Any ideas or opinions on that? What are the benefits and/or pitfalls, besides added complexity?:
This topic has been closed for replies.

2 replies

August 1, 2008
Maybe you could make it less transfer if you created stored procedures (minimize the amount of bytes being sent/received)... just an idea.
K9TAuthor
Participant
August 1, 2008
thanks. I had been planning to use stored procedures anyway in the hope that would be more secure.
Damon Edwards
Inspiring
July 31, 2008
I'd say post it all at the end instead of making all those http requests to your php file.