Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Smile Unanswered: dbload performance question..

    I have a 300,000 records data file that takes 7 mins for dbload to run. Is there a way to increase the performance of dbload utility???

    I am using Informix v9

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi,

    The only tuning you can do with dbload is tuning the number of rows before commit. Normally this is one large transaction, which is also the fastest. Of course can you do quite some tuning inside your databaseschema (indexes disabling for example) or in your configuration. But probably the best way to improve performance is using the high performance loader. I'll bet it will be really a lot faster.

    Hope this helps you a bit,

    Rob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •