Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete record is slow
Message
 
À
16/09/2003 12:59:49
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00829065
Message ID:
00829505
Vues:
19
Thanks Mike
Good suggestion. Now that you mention it, I knew that tip.
Thanks for the rattle, it works for losts of other coding!

>There was a recent tip in FoxPro Advisor magazine that says Rushmore Optimization does not work with object properties. You could do as Fabio suggested and copy the entire array property to a regular array or you could do this:
>
>
SELECT propnum
>FOR i = 1 TO ALEN(.aRemovePN,1)
>  * delete the property number
>  lnProperty = .aRemovePN(m.i)
>  DELETE FOR nproperty = m.lnProperty
>ENDFOR
>
>
>>Would anyone have an idea to why this code runs so slow. I think I may not be removing records from a view correctly. I couldn't get the view to update unless I deleted the record directly from the table. It takes 7sec on 33000 records, 5sec on 10000 records.
>>
>>	SELECT propnum
>>	FOR i = 1 TO ALEN(.aRemovePN,1)
>>		* delete the property number
>>		DELETE FOR nproperty = .aRemovePN(i)
>>	ENDFOR
>>        SELECT view
>>        REQUERY()
>>
Extreme Programming = Plan -> Design -> Code -> Test
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform