vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Are you re-preparing prepared statements in long-running processes and middleware servers after running update statistics? Often the update stats on an active table will invalidate the query plan computed when a statement is PREPAREd. The next time you try to EXECUTE such a statement or OPEN a cursor declared for it you will get a -710 error. Our middleware is coded to just reprepare the statement and try the EXECUTE/OPEN again when it gets -710. Possible, we're looking into it. Thanks, Jay sending to informix-list |