Thread

  1. Bulk-copy?

    Thomas Weholt <thomas@cintra.no> — 2000-06-02T06:08:33Z

    Hi,
    
    I need to insert about 2000-10000 records into a database. I`m using Python
    to do this. Is there a way to use some form of bulk copy that will do this
    faster than plain-old insert for each and every record?
    
    Thomas
    
    
  2. Re: Bulk-copy?

    Alfred Perlstein <bright@wintelcom.net> — 2000-06-02T08:56:20Z

    * Thomas Weholt <Thomas@cintra.no> [000602 01:45] wrote:
    > Hi,
    > 
    > I need to insert about 2000-10000 records into a database. I`m using Python
    > to do this. Is there a way to use some form of bulk copy that will do this
    > faster than plain-old insert for each and every record?
    
    I don't know if there's python bindings for it, but you may want to look
    to at the COPY stuff in the manuals, it's helped me quite a bit.
    
    -- 
    -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
    "I have the heart of a child; I keep it in a jar on my desk."