Re: inserting many rows

On Jan 2, 2006, at 5:34 PM, SunWuKung wrote:

> What do you suggest is the most effective way to insert this type of
> data into the db? Issuing multiple inserts from php seems to be a
> waste
> of resources.
>
> I was thinking of writing the responses into a pg array field with a
> single insert and than explode the content of that field into rows
> with
> a function.

This may help. But other than using some form of COPY, you'll
probably get the best performance increase using prepared statements.
Unfortunately, I think this is only available in PHP 5.1 and later.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL