Lock Table Overflow, Increase -l On Server (915)

[Densi Prabath]

I'm going to create a summery table for create a web view.
So when my process running "Lock table overflow, increase -L on server (915)" aspired.
in process, there are querying many tables. When get the error msg ,i edit my program and release all the table.now that error coming after long time.So how i avoid this error without increase -L

"Lock table overflow, increase -L on server (915)"

 

[KrisM]

You will need to look at your transaction scoping in your program.
Creating the summary should maybe not be one single transaction.

You may also try the -NL startup parameter in case the queries in your program do not all explicitely use the no-lock option.

 

[tamhas]

If this is just a display, there is no reason for any locks, so all of your reads should be no-lock.