Re: Need help loading huge table

In article <328CAF3E.41C6@nynexst.com>, Saul Rubin <saul@nynexst.com> writes >Hi all, >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. >Any suggestions?? >Thanx in advance. >Saul What version of the engine are you running? Do you disable transaction logging whilst you load the database? E.g. (example from the Online 7 performance Tuning course I went on at Informix) Time to load x (I don't remember how many) rows into the database Unbeffered logging 26 min Buffered logging <2 min! No logging < 1 min 30 seconds! -- David Williams