I purchased and installed DMX months ago. Since that time we've had major performance issues on our server and the size of our database has been bloating out of control (from 50MB to 800MB). We maximized RAM on our server and yet it still continues to have problems. I've been doing everything I can to keep my server up but its been choking and stopping responding several times a day.
I just identified the source of the problem. For whatever reason the server is locking and unlocking about 15 DMX documents every second 24 hours a day. The DMX_Log table contains 5 million records and growing every second. I've looked through the DMX admin settings and can't any setting I can change to try to correct this problem.
Do you have any recommendations on how we can regain control of this module and our server? If not, I'm going to have to notify my clients that we are removing the module from our server.
Thanks a bunch!!!
JT