[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing customers

Hi Charley,

I usually use COPY to import data.  For customers, there is no
downside to this and you get far fewer dead tuples :-)

Best Wishes,
Chris Travers

On 11/1/06, Charley Tiggs <..hidden..> wrote:

I have a large customer file that I need to import into the customer
table.  It's just straight up customer data, no shipto addresses,
nothing like that.  Doing this via the command-line interface takes
north of 20 hours (used to take longer before I was able to tweak my php
scripts to handle the file more intelligently).

My question:  Is there any downside to simply using COPY in psql to
insert those records?


Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
Ledger-smb-users mailing list