Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding items in a grid. Slow performance ??
Message
From
27/04/1998 13:10:56
 
 
To
27/04/1998 10:00:14
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00095070
Message ID:
00095193
Views:
21
>>I have a grid in a form to add records in a table. When the user begins adding records the performance is very good; but each time adds new record the execution of the form is slower. When he has append several records, is necesary to close form and reenter in order to have a good performance. ¿Any help on this?
>Carlos,
>If performance is getting worse as recco increases, check for any method calling routines that operate on whole table. And for a grid calling activerow is a performance degrader (ie: a column controlsource = this.activerow).
>cetin

Cetin,
I have no methods tha operates on whole table, except a sum command that use first a seek one and then sum rest... while. But i think this cannot be the problem cause if you close form and execute it again the performance returns good.

About 'activerow' propertie, i'm using it only in order to save which record we are editing:

m.fila = grid.activerow
activatecell(grid.activatecell(m.fila, 1)

Maybe this is the problem ??? If yes, How can i write a method that work only when the user moves into another row to ask him to save changes or not ???. I have the cursor with the buffermodeoverride propertie set to 4.
Saludos,
A.G.P.
---------
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform