Re: Ado SQL Concept question.

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/04/04 

Date: Wed, 03 Mar 2004 19:54:35 -0600

>I need to do single record lookups - thousands of times - now my SELECT
>statement works great and only returns the fields that my program requires.
>So I have tried to keep it simple. However it is just increadibly SLOW,
>when compared to the old dBase index file seeks. Is there anyway to
>optimize this query?

Why do you have to do single field lookups in a repetitive manner?
There isn't much speed to be gained in a better lookup strategy it would be best
to find out if your whole strategy is flawed.
With a database that can do SQL it is best to do most of the work in queries
rather than iterating records. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com