Board index » delphi » BDE & SQL Server

2004-09-14 02:17:42 AM
delphi173
Greetings,
I have a co-worker working with D5, BDE, and SQL Server 2000.
In the application is utilised a BDE component that sends
a 'batch' of SQL statements to be processed by the db server and
return a result.
Problem is that it appears to be running extremely long and he
is trying to figure out why it takes the server so long. It
appears to almost hang the system.
The BDE component SQL text contains the multiple SQL statements.
He does not get an error on the syntax of the statements, just
the amount of time it is takingto process them.
They will be rewriting the app eventually with other
capabilities and be doing away with BDE components, but for the
time being they must maitain this legacy application as written.
If anyone had any pointers in which I could have him look at
(properties of the BDE component, etc.), it would be greatly
appreciated !
G'Day !!!
Bruce VanOrder
 

Hi,
what happens if executing the statement with query analizer?
Same long time running?
Second: use the profiler, a very easy way to see what your
application sends to the server and what the server is doing
with the statements.
bye,
Helmut
 

Any posibilities of migrating the code from the Delphi application to a
Stored Procedure? It will decrease the network traffic and can be also
faster because SQL will have the code in the server.
--
---
Guillermo Castaño Acevedo
www.GrupoMillennium.com
"Bruce VanOrder" <XXXX@XXXXX.COM>writes

Hello,
Thank you for the reply...
That would be a possibility except it may prove difficult to place the
batch SQL statements in a stored procedure. These statements are
ad-hoc... meaning that they are different every time according to what
the users a performing. The SQL string is built according to the user
selections of various criteria (data, what type of output, etc).
Thank you once again....
Bruce
Guillermo Castaño A writes: