>I have noticed that running the same SELECT command (that accesses two joined tables) runs FASTER when the tables are first opened exclusively. Is this normal? Is there another way around this - that is, to get fastest speed when using SHARED files....
>Thanks in advance!
>Mark
Mark,
I find that as well. The unfortunate thing about that problem is, if there are many users accessing the same tables. Have you tried using a DO WHILE !EOF() loop and creating variables to access the table with the index file?? That seems to speed up the process for me. Before my USE statement I do a CREATE CURSOR and an INSERT INTO MyCursor before my SKIP statement. Don;t forget to set the indexes in the USE.
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.