MSCom
Neuer Benutzer
Threadstarter
- Dabei seit
- 20.09.2016
- Beiträge
- 1
I have a large table of dates and I am using an audit table to track the changes. Conditional formatting lets me highlight fields in my forms that have recently been changed using a function.
In the past I've been using DCount with a condition on the timestamp to determine whether there have been any recent changes. However, this causes performance problems as anytime a user scrolls through the lists, the cells are painted with conditional formatting and I get a lot of traffic from hundreds of DCount requests to my backend.
Now I've come up with a workaround: When a user opens the form that displays the dates, I pull the recordset of changes from the backend once and use this snapshot recordset to check for changes.
However, I cannot use DCount on a recordset. Do I have to write my own "DCount" or is there a more elegant solution? As mentioned, this is crucial to the performance of my application, so I appreciate every tip on how to do this as efficiently as possible.
Thank you
Raphael
In the past I've been using DCount with a condition on the timestamp to determine whether there have been any recent changes. However, this causes performance problems as anytime a user scrolls through the lists, the cells are painted with conditional formatting and I get a lot of traffic from hundreds of DCount requests to my backend.
Now I've come up with a workaround: When a user opens the form that displays the dates, I pull the recordset of changes from the backend once and use this snapshot recordset to check for changes.
However, I cannot use DCount on a recordset. Do I have to write my own "DCount" or is there a more elegant solution? As mentioned, this is crucial to the performance of my application, so I appreciate every tip on how to do this as efficiently as possible.
Thank you
Raphael