Skip site navigation (1) Skip section navigation (2)

Re: [PHP] Data insert

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-phppgsql-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

In response to

  • Data insert at 2005-08-20 17:17:55 from Postgres Admin

pgsql-php by date

Next:From: Andrei Verovski (aka MacGuru)Date: 2005-09-08 20:28:40
Subject: Getting list of Indexes & contrains
Previous:From: Michael FuhrDate: 2005-08-20 17:47:53
Subject: Re: Data insert

pgsql-admin by date

Next:From: Sivakumar KDate: 2005-08-23 04:24:38
Subject: Re: error codes in postgresql
Previous:From: Scott MarloweDate: 2005-08-22 19:49:00
Subject: Re: how to protect root access database

pgsql-sql by date

Next:From: Gary StainburnDate: 2005-08-23 08:33:58
Subject: diary constraints
Previous:From: Halley Pacheco de OliveiraDate: 2005-08-22 21:47:48
Subject: Re: SQL CASE Statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group