On 2016-11-03 12:14, Kevin J Cully wrote:
I created a subclass of the wwMaint.prg and then put that behind an authentication. I then added various PACKing routines: Some pack all tables, others pack the "vulnerable to memo bloat" tables.
The problem is getting exclusive access to the tables. If you're running in COM mode, then WWWC has a way of stopping all instances except one. If you're running in File mode which is what I'm doing, I have to remote in and kill the extra instances and then run the pack. It's a pain.
Not sure how it's being run, but I would suspect File mode. Terminal Server is involved with this client, which I've not dealt with before, but not sure if that's important for the matter at hand.
I've considered moving the table to PostgreSQL and not telling the client. Tempted but I haven't gone through with it.
I hear ya. I was thinking "man, I don't have this problem with MySQL (MariaDB)!!!!"