Re: Illustra performance with Web DataBlade

Posted in 1997

Seth Grimes — 30 Apr 1997 21:57:38 -0400 — source: Informix-list mailing list archive (1991-1998)

Peter Meyerhoff <pmeyerho@eb.com> writes: >I am experiencing major performance problems with multiple simultaneous >users on Illustra Web DataBlade. We tend to get very long delays and >deadlock errors. I'm not the tech guy, but is there anything I can pass >along that might help him resolve this? Thanks. Make sure all the select queries in your application pages set the isolation level (locking) appropriately. It should probably be read committed. I suggest setting a variable in the Webdriver (NSAPI or CGI) configuration file that looks like ILRC isolation level read ("read committed") or ILRC isolation level ("read committed") depending on whether you're running Illustra 3.3.0.18 (??) (2nd) or an earlier version (1st). Then the query syntax will be <?MISQL SQL="select a from b $ILRC where c;">...<?/MISQL> Seth -- Seth Grimes -- grimes@access.digex.net -- http://www.access.digex.net/~grimes grimes@magnet.com -- http://www.magnet.com