Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fastest Way to Search a Record On a Table/View
- Thread starter rexc
- Start date
SemperFiDownUnda
Instructor
ummm
SELECT *
FROM BLAH
WHERE Somecol = Something else?
What exactly do you mean?
Hope I've been helpful,
Wayne Francis
If you want to get the best response to a question, please check out FAQ222-2244 first
SELECT *
FROM BLAH
WHERE Somecol = Something else?
What exactly do you mean?
Hope I've been helpful,
Wayne Francis
If you want to get the best response to a question, please check out FAQ222-2244 first
- Thread starter
- #3
Thanks Francis!
Ok, I am currently using VBA(Access2000) as my front end and SQL2000 as my back end.
I have tried using "ado connection string" and make a query on VBA, but I got a slow response from my sql server.
I have also tried calling stored procedure on sql server but the response is still slow.
My computer specs is Pentium IV, 1.7G, 128MB DDR, and I still have 32GB of free harddisk space.
Is there any other way(faster way) which I can get a faster response from my sql server even if i have a large amount of data in the table that I am accessing to?
Thanks.
I hope I made a clear explanation.
Ok, I am currently using VBA(Access2000) as my front end and SQL2000 as my back end.
I have tried using "ado connection string" and make a query on VBA, but I got a slow response from my sql server.
I have also tried calling stored procedure on sql server but the response is still slow.
My computer specs is Pentium IV, 1.7G, 128MB DDR, and I still have 32GB of free harddisk space.
Is there any other way(faster way) which I can get a faster response from my sql server even if i have a large amount of data in the table that I am accessing to?
Thanks.
I hope I made a clear explanation.
SemperFiDownUnda
Instructor
Your limiting factor might be your network bandwidth. Are you pulling back tons of rows?
Run profiler on the server then run the query. Put that through index and tuning wizard to see if you can do anything on the db side as far as indexes go.
Just not enough information still to point you at your bottleneck.
Hope I've been helpful,
Wayne Francis
If you want to get the best response to a question, please check out FAQ222-2244 first
Run profiler on the server then run the query. Put that through index and tuning wizard to see if you can do anything on the db side as far as indexes go.
Just not enough information still to point you at your bottleneck.
Hope I've been helpful,
Wayne Francis
If you want to get the best response to a question, please check out FAQ222-2244 first
- Status
Similar threads
- Locked
- Question
