Delay in running DFD procedure

Questions and Answers about DataEase for DOS

Delay in running DFD procedure

Postby NReiff » Tue Mar 25, 2014 2:45 pm

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
NReiff
 
Posts: 21
Joined: Wed Jun 22, 2011 2:16 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Delay in running DFD procedure

Postby Phil Winkler » Tue Mar 25, 2014 5:51 pm

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.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Delay in running DFD procedure

Postby NReiff » Wed Mar 26, 2014 2:27 pm

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.
NReiff
 
Posts: 21
Joined: Wed Jun 22, 2011 2:16 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Delay in running DFD procedure

Postby Phil Winkler » Wed Mar 26, 2014 9:32 pm

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".
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 
 

Return to DataEase for DOS

Who is online

Users browsing this forum: No registered users and 3 guests

cron