Re: Load vs unload time differ. why?

Michael Mstowski wrote in message <34EC5A2B.67EAEE95@spaceworks.com>... > If I lock a table, shouldn't the load and unload be the same time? If >not, then why? What are the valid internal Informix database reasons >that a load time and a unload >time are different given that: >1) No indexes are used >2) The tables are locked in exclusive mode. > >Does a disk write take longer than a read? Log records are written for a write but not for a read in the above set-up. also When you are writing, there is data for the checkpoint to process and everything (or nearly everything) stops for a checkpoint. Maybe there should be a new chocolate bar especially for DBAs, called the CheckPoint ??? :->