Posted in 1997
Topics: Performance & Tuning, Transactions, Locking & Isolation
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
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.