When I save my dataset it takes far to long. (my database is growing and it gets worse)
After analysing, I discovered that the OnScroll-event is called very often. The code in the OnScroll-event is used to set formlayout dependent on data in current record (f.e. show/hide options).
Even when I disable the code in this event, it will still be called and therefor consume valuable time.
When I also need to refresh other (related) tables after a post, you can imagine that it will take seconds before a record is saved.
Can anybody give me some directions or an example on how to implement browsing and editting data with fast performance?
I'm using: Delphi 7 Pro, MS Access database, TADOTable, DevExpress
Thank you a lot for your help.