Well. I tried with all possible SET TABLEVALIDATE values.
It dit not affect the speed at all. Very slow with VFP8.
It might be a problem with the indexes when upgrading the
tables from VFP7 TO VFP8. Does any one have any experience
in upgrading tables from VFP7 to VFP8.
>>>>With VFP7 it takes less than a second to update the table.
>>>>With VFP8 it takes more than 3 minutes
>>>Have you checked out SET TABLEVALIDATE? This might be what's slowing you down.
>>No. What the SET TABLEVALIDATE has to do with the TABLEUPDATE ?
>
>If TABLEVALIDATE is set to 2 or 3, it validates the record count on every insert. I'm wondering if that could be your problem here.
Précédent
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