Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Marvin,
What size table (records and fields), with what field types and what was the Delete() state as well as the number of deleted records compared to non-deleted? Just trying to see what your baseline was before I start some of my own tests.
Renoir
>Here are some false Speeding issues reported by somebody
>
>Test it yourself and see.
>
>False statements:
>1. locate is much faster than a got top because its rushmore optimized. Got a 20-50 times faster with a got top instead
>2. do while !eof with skip is slower than scan .. endscan got a 6 times faster with do while !eof() .. skip +1 ... enddo
>
>Here is a real speed issue:
>
>1. Locate for !empty(date), or locate for date#ctod("") - use - locate for date#{} instead and get a 3-10 times faster command
>2. use the occurs() command instead of checking each character and get 300 times faster for those who didnt use it in their CSV commands.
>3. Set database to DATABASE and use table instead of use DATABASE!TABLE and get 2.5 times faster
>4. Only in development : Disable your standard symbol bar, because it shows the actual Database which has a great influense on the speed of set database to command
>
>Universalthread wishes:
>1. I would appreciate to have a Form with speed test commands in universalthread possibly with a grid on it showing the differences between the speed of commands.
>2. A similar to the speed test form but now for all the errors to let Microsoft use this form to repair VFP
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