Viewing 15 posts - 15,436 through 15,450 (of 18,923 total)
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...
July 8, 2005 at 7:05 am
Arhem :
type "GUI for mysql" on Yahoo : 2.1 M results.
July 8, 2005 at 7:01 am
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...
July 8, 2005 at 6:59 am
Hey Steve, I think you should have posted the solution in the article... might have saved 35 messages on this thread
.
July 8, 2005 at 6:57 am
"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...
July 8, 2005 at 6:55 am
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...
July 8, 2005 at 6:39 am
Can you post the table definition, some sample data and the expected results?
July 8, 2005 at 6:28 am
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...
July 8, 2005 at 6:27 am
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...
July 8, 2005 at 6:25 am
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.
July 8, 2005 at 6:23 am
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 :...
July 8, 2005 at 6:21 am
I'll take your word on this one... I never really worked with those (simple databind() but that's about it).
July 7, 2005 at 11:11 pm
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...
July 7, 2005 at 11:06 pm
Viewing 15 posts - 15,436 through 15,450 (of 18,923 total)