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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement