Re: inserting many rows

On 1/2/06 5:34 PM, "SunWuKung" <Balazs(dot)Klein(at)axelero(dot)hu> wrote:

> 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?

You could look at using COPY to insert many records very quickly. However,
inserting inside a transaction may be all that you need. Have you tried
simulating your application under expected loads so that you are sure that
you are making the right choice?

Sean