Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid performance. Need more help
Message
From
26/05/1998 06:10:23
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00101832
Message ID:
00101855
Views:
27
>>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.
>
>Did you try using buffermodeoverride to 5 to make it optimistic other than pessimistic. Also do not use SET FILTER commands if any.

I'll try buffermodeoverride to 5, we'll see. I dont use never set filter commands.
But, have you see this anytime else ? There's nobady has checked this problem ?
Saludos,
A.G.P.
---------
Previous
Reply
Map
View

Click here to load this message in the networking platform