Database Trafic

[clip4ever]

Question: I loop and read a set of records from a table. If I restart and read the same set of records again, does this cause another trip to the database or the program uses the records retrieved earlir ?

Thanks in advance

clip4ever

 

[opticalman]

Clip4Ever

First, I assume you are talking about a network shared databased.
Though I am not certain, I believe another trip to the database is made. I do know that all needed records are copied to the local machine from the network shared database. I am not sure if there is any procedures to check for changes in the main database and only import if changed.
But I know changes made to the database show up instantly.

Jim Rumbaugh

 

[JCreamerII]

Clip4ever,

I would agree with Jim. Windows might not think another trip is needed, but Clipper doesn't know any better. Assuming that you are starting at TOF, Clipper would grap the table at TOF again and run thru the dbf again, it doesn't know there is any other way.

Jim C.

 

[clip4ever]

I was afraid this is the case. Thanks