Re: Embedded SQL - performance question

I never done the tests such as those done by Joe and Chuck. But a year or
so back I needed to write an order inquiry. For the most part I used SQL
Selects, and it worked reasonably well (i.e., sub-second response). Part of
the inquiry, though, was to potentially (if the user selected it) display
the details for a billed order in the history. Maybe I was just
inefficient, but that puppy took forever (i.e.,> 15 minutes) to return the
records I needed. The history details was around 1,000,000 records at the
time (and growing). I changed it to RLA, and got back the sub-second
response. The index used for the RLA, which was equivalent to the SELECT,
existed before I started writing the program.