Can't find source of select * from
Posted: Mon 15 Jun 2015 09:02
Hi
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
Our lead developer has scoured the source code and cannot find the source of this query which leads me to suspect that it is not being called directly but rather as a precursor to or bi-product of some functionality, Presumably it would be there in order to load that table into memory.
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
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