Help! blocking problem! BDE-SQL_SELECT
Posted on 2000-03-02
we are facing a VERY VERY serious problem that
some insert/update statements passed to M$-SQL server are blocked in high frequency.
After analysis, we found that the SQL server will perform an INTEND-SHARE lock at once
on the table[assume with LARGE size] that a TTABLE associated
once the TTABLE is active. (will not happen on small tables)
We trace the SQL execution and found that
BDE will generate a SQL select statement and pass it to SQL server for execution
but never end because it did NOT receive all records
til a TTable.Refresh or TTable.Close;
Hence, sometimes, some updates on the table unfortunately were blocked.
At this moment, we have to set some guidelines : such as,
always append Table1.Refresh after Table1.Open at once.
but it just can reduce the frequence.
I knew change TDS PACKET SIZE to highest value can reduce the frequence
but some tables are in VERY large size(> max(TDS Packet Size))
Any advices/comments are appreciated.
(MORE points are being prepared.)