Rambling:
My company develops its application using Borland C++ Builder 5 and have recently migrated from using the Borland Database Engine over to SDAC, the transition has mostly been seamless but at one of the sites where our software is installed we have found that a 'Lock request timeout' occurs quite frequently which seems to be caused by queries waiting with the wait type ASYNC_NETWORK_IO . The offending query that was causing the ASYNC wait is
Code: Select all
select * from participants
Question: Are there any objects or functions of SDAC that call 'select * from ....' behind the scenes?
It'd be much appreciated if someone could help with this matter and as this is my first post please let me know if more information is required to be of assistance.
Thank you all