Re: Informix data extraction

Hi there, one point I would make is that it is worth editing the SQL contained in the dbexport SQL file. This is used to recreate the database on load. The structure of this is to (generalised): Create the Tables Create the Index(s) and constraints Load the data. This is very slow for large loads. The best thing to do is to edit this SQL file to do the index creation after the load if this is possible. You will see a huge increase in speed. Craig.