Page 1 of 1

Delay in running DFD procedure

PostPosted: Tue Mar 25, 2014 2:45 pm
by NReiff
Maybe I am just getting old but it seems that in the morning when I run a procedure which looks to 42000 records and is properly indexed, it is taking abnormally long (about 30 seconds/maybe longer) to run the procedure. After running this the first time, the next time I run the same procedure it takes one second.

This is on a per-to-peer network machine. The printers.dat and denetwrk.ovl files reside on the local computer on which I am running the program.

Is this normal?

Neil

Re: Delay in running DFD procedure

PostPosted: Tue Mar 25, 2014 5:51 pm
by Phil Winkler
Could be a lot of things. Have you Excluded the data folder from being scanned by Antivirus software?

What is the WITH statement? Could be you are experiencing the Cartesian Catastrophe having 2 indexed fields ANDed together.

Re: Delay in running DFD procedure

PostPosted: Wed Mar 26, 2014 2:27 pm
by NReiff
Thank you Phil. The anti-virus thing never occurred to me. No, it was not excluded form the anti-virus scan.

As for the with statement, it is:"With Memo# = data entry ENTER MEMO# and STATUS = Open". Both fields are indexed. I am not sure what you meant in "Could be you are experiencing the Cartesian Catastrophe having 2 indexed fields ANDed together".

Again, I repeat that the procedure is quick after the first time that it runs in the morning. Just after being idle overnight that it takes a while.

Re: Delay in running DFD procedure

PostPosted: Wed Mar 26, 2014 9:32 pm
by Phil Winkler
With Memo# = data entry ENTER MEMO# and STATUS = Open".

This could cause the Cartesian problem. I assume Memo# is unique?

Try this and see what happens:
With Memo# = data entry ENTER MEMO# and firstc(STATUS,4) = Open".