Fastest Way to Search a Record On a Table/View

[rexc]

Hi there!

For those techies out there... Please help.
I need your comment on what is the best/fastest way/method to filter a record.

Thanks.

 

[SemperFiDownUnda]

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

 

[rexc]

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.

 

[SQLSister]

HAve you indexed your table?

 

[SemperFiDownUnda]

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