RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

Author: mbsoftwaresolutions@mbsoftwaresolutions.com

Posted: 2016-11-03 at 11:18:54

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)!!!!"

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/cc8411a987f812f31ad19416984a32ef@mbsoftwaresolutions.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2016 mbsoftwaresolutions@mbsoftwaresolutions.com