> > 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