inserting many rows

From: SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: inserting many rows
Date: 2006-01-02 22:34:47
Message-ID: MPG.1e23c8f31a51a429989680@news.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I will need to insert multiple rows into a table from php.
The data will come in 'packages' of 50-500 rows (they are responses from
different questionnaires). As there will be many people sending their
results in at the same time I need an effective method for this.

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.

Could you suggest an efficient aproach?
Thanks for the help.

Balazs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Wasson 2006-01-02 22:45:13 Re: using PG with Syslog
Previous Message Tyler MacDonald 2006-01-02 22:33:43 Re: inserting many rows