SQL Speed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Baima - 17 Dec 2004 20:37 GMT

Ive been working on a program that uses SQL Server and Ive noticed
that the same SQL query run in Query Analyzer is often 10 times faster
than the same query in VB. Besides, thats just VB, is there a good
reason for this or could I be doing something wrong to make it that
slow? I tried playing with the adOpenStatic, adLockReadOnly
parameters, but that seems to have little or no effect. Any
suggestions? Thanks!

-John

Reply to this Message

Jason Tost - 28 Dec 2004 23:26 GMT

> I’ve been working on a program that uses SQL Server and I’ve noticed
> that the same SQL query run in Query Analyzer is often 10 times faster
[quoted text clipped - 5 lines]
>
> -John

What's your VB code look like that is taking the performance hit?

Reply to this Message

Gijs Beukenoot - 31 Dec 2004 11:27 GMT

Het is zò dat Jason Tost formuleerde :

>> I?ve been working on a program that uses SQL Server and I?ve noticed
>> that the same SQL query run in Query Analyzer is often 10 times faster
[quoted text clipped - 7 lines]
>
> What's your VB code look like that is taking the performance hit?

Where is the resultset (adUseServer / adUseClient) stored

You could use the profiler to see what's it doing and where the delay
might come from.

Signature

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>

Reply to this Message

VB Forum / Database Access / December 2004

SQL Speed