Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only