Re: Database backups

Posted in 1992

Hugh Grierson — 6 May 92 20:56:58 GMT — source: Informix-list mailing list archive (1991-1998)

In article <8858@emory.mathcs.emory.edu> bob@worms-emh2.army.mil ("Robert F. Kane") writes: > >> "update statistics" (6 hours on a 10GB database) > >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. Certainly. Possibly because of the extra statistics kept on indexes. This stung us when a client moved from SE to Online. Some interactive programs were doing "update statistics", albeit unnecessarily in many cases, and this was taking ~15 min (.5 GB database). From these 2 data points count on around 30 min per GB +/- grains of salt. -- -Hugh Grierson--hugh@fivegl.co.nz----------Go fast or go home---------------- -Task Management Ltd-Auckland-New Zealand-Ph:+64.9.5206109-Fax:+64.9.5206101-