Speed Info
Posted: 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
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