One question comes to mind... I know that the server is probabely more powerfull than the user's pc. But still 60 times faster???? This sounds to me like...

Arhem :

type "GUI for mysql" on Yahoo : 2.1 M results.

I tried this one but it failed...

Also he said that he wanted to do more than one operation on the form... so it's faster to set it to a variable...

Hey Steve, I think you should have posted the solution in the article... might have saved 35 messages on this thread .

"Now knowing what you mean by "set based approach", I agree that in many cases this can replace cursors and will be faster. But I am not convinced that it...

Just a theory...

How about using blind carbon copy .

I know that there are other situations where you have no choice but they should be...

Can you post the table definition, some sample data and the expected results?

Without reading the whole thing in details :

Are all the columns listed in the join statements indexed?

Is there a way to remove some of the left and right joins...

He wants asynchronus execution. It think that your best bet is to start 2 threads in the application and opening 2 recordsets using 2 connections. This can be...

Can you post the code of the stored proc? I have a code generator for vba code that can generatea more optimized version of the code.

While Micheal is right you might wanna learn some more basic stuff first (you'll just be lost for too long in the tsql forum). I'd suggest this tutorial :...

I'd use the DTS database transfer wizard... but in seconds that might be asking a little much. How big is the oracle db?

Are they on the same server (is...

I'll take your word on this one... I never really worked with those (simple databind() but that's about it).

The one and only case I'm aware of is this one :

Let's say you want to get the nth line of a big query, it's sometimes faster to open...

I just hope I won't be one of those guys .