Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid performance. Need more help
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00101832
Message ID:
00102175
Views:
22
Carlos, I haven't seen this problem when adding data in grids. Could the problem be the command button? Would it be possible to remove this column and put a single button on the form which updates (saves/calculates) data for the highlighted row/record?

Also, unless your users specifically want to have table buffering, you might try to set the buffer mode to Row buffering, which forces the data to update whenever the record is changed.

HTH
Barbara

>In the past i've talk about this question with i dont remember who. I've tested the solutions povided by him, but they doesnt works. The problem is:
>I have a form with a grid bounded to a child table of a master one. The cursor of the table in the DE has the buffermodeoverride set to 4. The grid has 10 columns, some of them with the sparse propertie set to .f.. One of the columns has an commandbutton that executes the code in order to save changes in this record and do some calculations. The grid allowsaddnew = .t.
>Everything works fine, but performance of grid goes slower each time user adds a record. If the user exits the form and reenter it, performance returns good.
>My user must add thousands of records each day, so he must exit the form and reenter a lot of times in the day. I've suprresed all count, sum... clauses.
>What can i do or test?
>Is better to use a transaction instead of the buffermodeoverride ?
>I'm absolutely lost.
>Thanks every one now and in the past.
>Carlos.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform