I am retrieving both tables and views from Oracle (VFP will not recognize my index keys when I select then into a remote view, thus making joins very hard to do). I had turned off autoarchive, but then ran out of space on the archive log ( Connection Error: End of file encountered) which crashed my import. At present, I am trying once again to finish the import. A select statement within a loop on an oracle base table is averaging 82.34 seconds, and reaching over 100 seconds. The query is mereley maing certain that the record is not already in the table

select sernum from pers where pers.sernum = m.sernum into array temp;
if _tally <> 0
yadda yadda

So, speed is a vey major concern. I am using the "latest and greatest" driver, the one supplied with Oracle 8.0.5.