Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-17 : 12:56:30
|
| Fabian Ramirez writes "I'm having long delays when calling a stored procedure from a multithreaded delphi application with bde using tcpip. When I run the application in the same machine where sqlserver is located i get 80 or more runs by second. But when I run the application in a workstatation I get 12 or less runs by second, getting a behavoir of a rapid excecution of n (n is the threads i'm using) runs of the procedure then a delay, and again a n rapid runs of the procedure...Any Idea..?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-17 : 12:58:30
|
| Well, yeah, if you run the app on the same machine as the SQL Server resides it does not have to contend with network traffic overhead, or any delays in the network outside its immediate loop.Have you tried posting your question in a Delphi forum? They will probably be better able to answer this question for you. |
 |
|
|
|
|
|
Long delays between stored procedure calls from delphi