Re: dbexport/dbimport problems

} } Hi, } } We have a production database that has been live for about a } year. Application performance on this database has been fine. } } As the number of extents for some tables was becoming excessive, } a full dbexport/dbimport was carried out on the database. Although } no problems were experienced during the export/import, once the } system was live again, the performance had degraded *significantly*. } After a days use, the performance is still awful. I had expected } the performance to increase. } } Has anyone had similar experiences following a dbimport, or can } anyone explain what the problem may be. } } INFORMIX-OnLine Version 4.10.UE1 I would suspect that the tables are now in a zillion extents, since they were not specifically set. Dbschema does not capture extents. tbunload/tbload will greatly lessen the extents. } } } Regards } Tony } -- } ---------------------------------------------------------------------------- } Tony Desborough SRL Data Ltd } Software Programmer 1, Perren St } Email: tony@bilpin.co.uk LONDON, NW5 3ED } -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ---------------------------------------------------------------------- It's almost impossible to overestimate the unimportance of most things.