Re: Need help loading huge table

Saul Rubin wrote: > > I need some help. A client of mine has a table which needs to be loaded > on a regular basis. The table currently has about 20 million records and > will probably grow to 50 million within a few months. The table has > 7 fields (mostly int's). I have a C program which generates a flat file > which I then load into the table. After all the data is loaded, the > indexes are created. This takes HOURS. What about ESQL/C to bypass the flat file? What version of the engine are you using? What platform? How many CPUs? If version 7.xx are you using PDQ? If version 7.2x what about the high performance loader? Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+