Re: update statistics slowing system

Posted in 2003

Jonathan Leffler — Thu, 13 Nov 2003 05:24:30 GMT — source: Usenet: comp.databases.informix

John Carlson wrote: > On Wed, 12 Nov 2003 20:10:19 GMT, "Glen Johnson" <glen@csisoft.com> > wrote: > >>Should doing an update statistics on a table in one database affect the >>preformance of users in a totally separate database. Does it lock some >>global tables? I don't think it is a CPU problem since this is on a 6 >>processor Linux system. > > No, but disk access may be a bit of an issue . . . . And so can the version - more recent versions of IDS have much better performance on UPDATE STATISTICS for a variety of reasons. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/