Hi,
I am using local view to update records in a module. The view will query about 5000 records which contains 4 fields (about 100 bytes per record).
I am using view designer to set the view's property. The settings are as the following:
SQL Generated: SELECT f1,f2,f3,f4 from mytable where f1 = .f. order by f1 asc
Fields name in update criteria: f1 (updatable), f2 (key field), f3,f4
SQL WHERE cluase include: Key fiedls only
Update using: SQL Update
Send SQL updates: TRUE (checked)
The query takes 6 seconds to load data. It is ok since i am using 10BASET LAN. However, this view also take 6-8 seconds to update records. The view is buffered using 5-TABLE BUFFERING and updated using TABLEUPDATE(2, .F.).
Any ideas for the reason of slow update?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...