>...Carlos buffering doesn't reduce performance considerably. I couldn't follow the whole thread but did you use "activerow" anywhere in this grid (ie: as a RO controlsource)? It's the most performance penalty I could find for grids. When I first used it and table grow to some large amount users would nearly go for a coffe break after pressing up-down arrows.
>>Cetin
>
>Cetin,
>We've talk yet about it: In the past i have used the activerow property, but i've removed them from the code. No results. The table is very long, but i'm using it as a chind record of other one. Doesn't matter how long is, when you begin your session adding items, performance is good, but each record you adds, go decreasing, and after 80 or 90 items added you can have a long 'dinner break'.
>
>You close the form, re-enter and performance returns good. I've tried all the sugestions in this thread but no results. Now i don't know what more do.
>Carlos.
Carlos,
I think you wouldn't want to do this (I did). Instead of using the large child, select related child recs into a read&write cursor, use table buffering, edit/append, loop through modified and update original. It's exceptionally fast with large tables.
Cetin