AW: AW: delete performance

Posted in 2006

Model-Bosch, Tilman — Thu, 19 Oct 2006 14:50:53 +0200 — source: Usenet: comp.databases.informix

>Von: Floyd Wellershaus [mailto:fwellers@yahoo.com] >Gesendet: 19 October 2006 14:39 >An: Model-Bosch, Tilman; informix-list@iiug.org >Betreff: Re: AW: delete performance > I noticed when looking at your query of sysseswts, and the onstat -g wst > that we don't have wait statistics enabled. > Is there any reason we shouldn't enable that ? Does it use many resources ? There has been debate on whether or not to turn it on by default. Some say it uses resources (CPU cycles) some say it does not make a significant difference. In SAP systems it is always turned on by default and I never saw evidence of performance difference due to WSTATS. I guess it might have some performance impact in particular circumstances Most of the time propbably it wont. Regards Tilman

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g