| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Aldor <an(at)mediaroot(dot)de> |
| Cc: | Postgres Admin <postgres(at)productivitymedia(dot)com>, PostgreSQL - Admin <pgsql-admin(at)postgresql(dot)org>, PostgreSQL - PHP <pgsql-php(at)postgresql(dot)org>, PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [PHP] Data insert |
| Date: | 2005-08-23 00:57:52 |
| Message-ID: | 20050823005752.GI17203@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-php pgsql-sql |
On Sun, Aug 21, 2005 at 06:35:22AM +0100, Aldor wrote:
> if you want to insert biiig data volumes try either using COPY instead
> of INSERT - it will run much much faster
And if for some reason you have to stick with inserts, group them into
transactions; it will perform much better than individual transactions.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sivakumar K | 2005-08-23 04:24:38 | Re: error codes in postgresql |
| Previous Message | Scott Marlowe | 2005-08-22 19:49:00 | Re: how to protect root access database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Verovski (aka MacGuru) | 2005-09-08 20:28:40 | Getting list of Indexes & contrains |
| Previous Message | Michael Fuhr | 2005-08-20 17:47:53 | Re: Data insert |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Stainburn | 2005-08-23 08:33:58 | diary constraints |
| Previous Message | Halley Pacheco de Oliveira | 2005-08-22 21:47:48 | Re: SQL CASE Statements |