Speed Info

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
franco
Posts: 296
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Been thanked: 9 times

Speed Info

Post by franco » Sat Mar 31, 2018 6:46 pm

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 ;)
Franco Bushie
Canada

Post Reply