Re: Database backups

Posted in 1992

Robert F. Kane — Wed, 6 May 92 13:47:40 GMT — source: Informix-list mailing list archive (1991-1998)

David, > The annoying feature of DBEXPORT is that it does an "update > statistics" (6 hours on a 10GB database) before writing anything to > tape. But once it starts writing, it is fast. I can't imagine why > it needs to do that because doing a select count(*) on each table is > virtually instant. I find that curious, I have a database with approxiamately a million records and I can do an update statistics in about 20 seconds. Another difference between SE and ONLINE perhaps. We are using SE 4.0 UG1 on a AT&T 3B2. ----------------------------------------------------------------------------- Bob Kane Internet: bob@worms-emh2.army.mil (IP 134.235.9.2) TechDyn Systems Voice: (049) 6241-75936 (WORMS, GERMANY) CMR 421, BOX 706 Fax: (049) 6241-500154 APO AE 09056