General information
Category:
Coding, syntax & commands
Hi all-
I am importing the results of a regression run to an existing fox table, using odbc. After I get an import cursor for use in VFP, I scan it and replace each field in the target table as I find the record, like so:
SCAN
IF INDEXSEEK(EVAL(lcSeekExpr),.T.,lcTargetTable,.cPKIndex)
REPLACE (lcTargetField) WITH EVAL(.cSourceField)
ENDIF
ENDSCAN
(the import cursor always includes the fields for the pk of the target table.)
This takes about 13 minutes for 18,000 records on my local machine. I'm wondering if I should do an SQL select and join the two tables, and then overwrite the target table with the output cursor. This might speed it up, but I'm not sure of the other implications for the data - for instance the target table could be involved in several relations. Any ideas for optimizing this would be much appreciated-
TIA-
Carlie
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