Posted by "Richard Lynch" on 07/22/05 05:44

On Thu, July 21, 2005 6:52 am, JamesBenson said:
> Thanks for your reply, your example demonstrates what i was doing but
> does that do a MySQL query for every piece of data?
> So 20 form values would be 20 db queries, would that not consume a lot
> of resources?
> Is their another way?

Test it on your server.

20 INSERTS is pretty much chump change, really...

I mean, sure, if you're server is getting SLAMMED and you are executing
this page a thousand times a day or something.

Otherwise, your are really NOT looking at a lot of overhead for those 20
queries.

Time It.

I doubt that the prepared statements give much performance boost for only
20 queries, but, again, time it on YOUR computer.

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]