Active Record Multiple Insert

[eluser]BizComputing[/eluser]
I could be totally off base on this, but, I think the real performance diff doesn't come from the connection since if I recall, persist connections are for maintaining a connection between page requests, not sql statement requests.

I think the real performance diff is in 1 how much info needs to be piped between php and the db ( ie, seperate queries have to have a full query def ), and the time it takes for the db server to parse the query.

But the flip side of an all in one statement may be more lock contentions.