Speed Info

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
franco
Posts: 816
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Location: Canada

Speed Info

Post by franco »

I have a file INV with a field lastuse and 60,00 items
If I create a window with a datepicker
Because I can still not get sql select from to work I create a temp file.
If I use append from Inv for lastuse <= datepicker.value it takes 12 to 18 seconds depending on the date.
HERES WHAT I FOUND.
If I create a local variable D1 equal to datepicker.value and use:
append from Inv for lastuse <= D1 it takes 3 to 4 seconds depending on the date.
I seems a variable is faster by 4 times to check then a window item.
NOW I CREATE A LOCAL VARIABLE FOR EVERY WINDOW ITEM I WANT TO CHECK....... MUCH FASTER.
Franco ;)
All The Best,
Franco
Canada
Post Reply