>
> In VFP5.0a, I compiled an OLE DLL with 2 selects. The first selects from
> an indexed table of 300,000 records into a cursor. The select is fast. I
> then need to select from the cursor. I get an error saying the cursor I am
> selecting from must be created with "SELECT... INTO TABLE". This is good
> and everything, but selecting from the original table into a file, greatly
> decreases the speed because now it has to write the resulting file
> physically to a table where before it was just a subset of the larger
> table. Has anyone been able to get around this and not lose any speed?
1: how many of those 300,000 records generally end up in the first
cursor?
2: could you select the key fields from the table into a physical file,
and then do a Join in the select with the original table? If you index
the results of the first select, you might not see a performance
problem.
3: is the first select just creating a subset of the original .DBF, or
is it being dumped to a separate table? If the former, then try it with
the NOFILTER clause. It should help to have your SORTWORK directory be
local and have a fair amount of room.
/Paul