how to stop a long query
how to stop a long query
Is there any possibility to stop long query (ex. after 30 sec.) on MS SQL?
Directly using DBExpress?
Externally using periodically activated stored proc?
Other solution?
Typical application:
- user connect
- user search data (different queries)
- user run complicated query and wait ... after 30 sec. query expires
(program can continue, query also stops physically on MS SQL)
Thanx
janog
Directly using DBExpress?
Externally using periodically activated stored proc?
Other solution?
Typical application:
- user connect
- user search data (different queries)
- user run complicated query and wait ... after 30 sec. query expires
(program can continue, query also stops physically on MS SQL)
Thanx
janog
and SDAC has interface to setup local timeout for some query?Ikar wrote:dbExpress doesn't provide an interface for this functionality. Probably, you should look for solutions used MS SQL ability or start using SDAC.
and how exactly... can stop query physically on SQL server.. or only doen't wait for query end and SQL server continues to process query?!
migration to SDAC
ok.. is there any list of important notices and advices when migrating from dbExpress driver "dbexpsda" to SDAC ?
differences?
limitations?
known problems?
link to some papers? help files?
thanx
differences?
limitations?
known problems?
link to some papers? help files?
thanx
dbExpress technology serves for most possible unification of accessing different servers (MS SQL, MySQL, Oracle and so on). It is Based on drivers including all specific of working with the certain server. As any universal tool, at the most specific cases dbExpress loses to specialized methods. For example, dbExpress design-time is quite poor and couldn't be expanded.
SDAC is a specialized set of components to access MS SQL Server with advanced design-time, with interface similar to BDE-components.
We tried to implement maximum support of MS SQL in SDAC and DbxSda, but at the last one, dbExpress technology puts restrictions.For example, Unicode fields cannot be passed from the driver to dbExpress.
SDAC and DbxSda use the same kernel, as a result they have similar performance. As for access OLE DB - the lowest level from documented protocol to work with MS SQL is used, the speed is quite high.
Verdict: if a possibility to re-build your application fast from using MS SQL to another server is important for you, you'd better use DbxSda. At the rest cases, especially on migration from BDE or ADO, you should use SDAC.
SDAC is a specialized set of components to access MS SQL Server with advanced design-time, with interface similar to BDE-components.
We tried to implement maximum support of MS SQL in SDAC and DbxSda, but at the last one, dbExpress technology puts restrictions.For example, Unicode fields cannot be passed from the driver to dbExpress.
SDAC and DbxSda use the same kernel, as a result they have similar performance. As for access OLE DB - the lowest level from documented protocol to work with MS SQL is used, the speed is quite high.
Verdict: if a possibility to re-build your application fast from using MS SQL to another server is important for you, you'd better use DbxSda. At the rest cases, especially on migration from BDE or ADO, you should use SDAC.
Important for me is to run my application against MS SQL and ORACLE... now i'm using dbExpSDA but limitations of dbExpress .. unicode fields and long queries (no support for Command Timeout) brings me to the idea of using SDAC...Ikar wrote:Verdict: if a possibility to re-build your application fast from using MS SQL to another server is important for you, you'd better use DbxSda. At the rest cases, especially on migration from BDE or ADO, you should use SDAC.
So... can I use ODAC and SDAC in one application? Is there any possibility to use compiler directives?
I mean... some units special for SDAC an ODAC.
Rest of program can use some Parent Class ... Are sources of ODAC and SDAC based on similar structure of classes or not...?
It is importat to me to decide to buy SDAC and later ODAC....
Thanx
You can use SDAC and ODAC simultaneously. The only restriction is that builds of both products must be compatible, released at the same day.
> Are sources of ODAC and SDAC based on similar structure of classes or not...?
Yes, these products use common classes and too close between themselves. The difference is only at server-specific features.
> Are sources of ODAC and SDAC based on similar structure of classes or not...?
Yes, these products use common classes and too close between themselves. The difference is only at server-specific features.