Scanning through a Table is Slow.

[Cohagen23]

Sometimes, when I run a scan through my inventory table it reacts very slow. I Placed a message line in the scan to show how fast it is going. It used to do this program pretty fast. What can be problem? I am using Paradox 9.

 

[Bystander]

Is it possible that you have more users than before and the scan has to keep waiting for records to be unlocked?

 

[Cohagen23]

Maybe So, But can I maybe lock the table while the program is running. I only have 6 users and probably never have 2 in the inventorty table at on time yet the program does one scan and it takes twenty minutes. I'm pretty sure it is not a refresh problem and norton is turned off.

 

[shraga]

Try pack the table.

 

[Bystander]

Before considering locking try the scan when no one is in the table.

Would you be happy to share the code for the scan, the table structure and no. of records. It might be that there is a logic error in the scan. I think that sometimes a scan can repeatedly perform an unnecessary operation on each record rather than skip over them, it is based on how the scan loop is written.

Regards

Bystander

 

[Cohagen23]

It is a pretty simple scan - I run all my scan tables this way - any help would be appricated.


method pushButton(var eventInfo Event)
var

tc_item tcursor

endvar


tc_item.open("inventory-item master.db&quot
tc_item.edit()

scan tc_item:
PN2=tc_item."Part Number"
Message("Scanning Part Number",PN2)
tc_item."Qty on PO"=0
tc_item."Qty on WO"=0
tc_item."Qty Committed"=0
endscan
Rv.open("Inventory Report.RSL&quot

endmethod