All,
I recently split my first database application into a front end/back
end server application for distributed users to get out of managing
the day to day data entry and to focus on more productive activities.
All appears to be working as intended with one very major exception.
It appears that any queries (or re****ts relying on queries) containing
DSUMs are running painfully slow. I'm fairly certain the DSUMs are
the culprit given before and after performance comparisons. I realize
now it was a bad decision to use DSUMs, even for a novice hack like
myself.
What's the best path forward to replace all the DSUMs with something
faster in a multi-user, server-based environment?
Note: I generally have no more than five users connected
simultaneously, and all traffic is confined to a cor****ate intranet
for the time being.
Thanks for your advice,
Tom
