Walter Meester
HoogkarspelNetherlands
Bruce,
>>Has anyone else experienced a problem with INDEXSEEK?
>
>I'm not quite sure, but maybe. I have a loading program that imports data, and sifts through many GBs of different very large tables with the following type of code:
>COPY TO (tablename) DATA (dbcname) FOR !INDEXSEEK(field,.F.,table,index)
Try a:
COPY TO (tablename) DATA (dbcname) FOR KEYMATCH(IndexExppr,TAGNO(Indexname),cAlias)
If there should be a kind of filter active you can add the filter in the FOR clause of the INDEX command.
It should be far faster than INDEXSEEK()
Walter,
>It's not pretty, but in testing ideas it was by far the fastest. However, I have had occasional memory error messages running this section of the app. Not frequent, only occasional, and it may be due to something else, since there are a lot of very large files being shuffled around in this app. So, your theory is possible, I would say.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only