Recent content by mellamokb

Yeah, that is a good suggestion. When the user is done working with employee management it could probably do the reorder once afterward. The general problem is I know there are numerous places in our production application where recordset loops are used to batch process and I was hoping to...

Hmm. I added the folder with my Test database as Trusted Locations and the behavior seems similar. I suspect because I'm comparing performance between two different function in the same database, not two different databases.

Yeah, that's the conclusion I'm coming to as well. What's annoying is that the listbox doesn't have this behavior without the Data Macro. You can happily do a recordset loop and update every record in the listbox with no performance hit. The problem seems to only manifest in combination of a...

The listbox is simulating the behavior of the real application, where we have a listbox on the side bar of the employee screen for selecting the current active employee. I was trying to construct the minimum repro.

GPGeorge - I apologize as I'm new to the forum so I'm trying my best to communicate, thanks for taking a look at this. On my previous reply from yesterday at 4:40 PM you should see an attached ZIP file with a test database once you unzip. This database provides repro if you do these two...

Ooooh.. I just tried this and it made a difference! It seems there is some undocumented interaction between Data Macro and bound objects to the same table. Temporarily unbinding it does seem to make performance back to expected. And re-binding the data source still keeps the state intact...

Appreciate all the responses. I guess the answer is clear, Data Macro is not a great solution for our current product without major refactoring :) Describing as audit wasn't really useful, but that seemed to be what everyone else uses Data Macros for. Technically this is for two-way sync to a...

GPGeorge - I think this should do. It has tblEmployee with Before Change DM that sets LastUpdated on affected rows. Then a frmTest with action button, and a bound ListBox to tblEmployee. If you directly run test() Macro (like immediate Window) which calls ReorderEe, it prints something like...

Thanks for the numerous responses! First, I am aware this is not ideal, you're preaching to the choir :) We're on an evolutionary strategy toward something better, but it's a multi-year plan. Second, I want to be careful to communicate the subtlety of what I'm asking. The DM performance is...

Thanks, theDBGuy! Main reason I chose Before Update is because I wanted to update a column in the same row, and I don't think I can do that easily with After Update. Plus I thought it would be the highest performance at scale/volume - This is primarily for the foundation of a sync tool, and I...

Hi All- We are exploring the use of Data Macros to add audit tracking to our core product. But it has strange effects on performance that make it unreliable solution. Maybe someone can help diagnose the following. Here is simplest way to repro. 1. Build blank app with a table like...