Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow Tableupdate in vfp8 ?
Message
De
13/06/2003 13:39:56
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Slow Tableupdate in vfp8 ?
Divers
Thread ID:
00799905
Message ID:
00799905
Vues:
77
With VFP7 it takes less than a second to update the table.
With VFP8 it takes more than 3 minutes
I compiled the same project with VFP8 and reindexed the database using the
Stonefield SDT tools.
I recompiled the project again with VFP7 and runs, as usual,
with the speed of light.
What might be the problem ?
********* the code *********
* the Temp_curs is a cursor of about 50 records
* the Invhed is a table of a bout 250000 records
* there INVHED table has an index on CODE field

Begin Transaction
m_sys=SYS2015()
SELECT temp_curs
Go Top
Scan 
	M_ CODE= temp_curs.Code
	Update INVHED Set ;
		katpel= m_sys WHERE INVHED.Code=M_CODE
Endscan


If  ! Tableupdate(1, .T., "INVHED")
	=Messagebox(" Problem in updating: INVHED ", 16, oApp.Title)
	Rollback
	Return
ENDIF

End Trans
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform