S
steve pittman
Guest
On 6/23/2014 8:24 AM, esemashko wrote: RE: How to get too much records via ODBC and PHP? Reply by esemashko I tried to increase ArraySize in DSN, but server stopped with message: [ 2014/06/23@03:03:30.562954248389133+0400 ] P-18855 T-1749755648 I SRV 2: (915) Lock table overflow, increase -L on server L = 16000 Stop receiving emails on this subject. Flag this post as spam/abuse. You may be running with a Transaction Isolation Level of Repeatable Read, if you get 16000 locks. Repeatable Read will lock every record read until end of transaction. You may not need this behavior. You might try using Transaction Isolation Level of Read Committed. The isolation level can be set in the ODBC Data Admin for the DSN. This assumes that your app and PHP do not over-ride the isolation level defined for the DSN. If your applications is also writing to the db via Insert/Update/Delete while reading, then the isolation level has no effect on locking for writes, and these will not be affected. Hope this helps, ......sjp
Continue reading...
Continue reading...