Over inflated EmailMessage.MYD

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
drawab
Posts: 46
Joined: Tue Apr 01, 2008 4:57 am

Over inflated EmailMessage.MYD

Post by drawab » Thu Apr 17, 2014 1:55 am

Hi

I just noticed that one particular file EmailMessage.MYD is over inflated to over 1.5GB - it could have been that the software may have downloaded all the emails from the practice google / gmail account and have it archived into its own system

OR is this file a record of all emails sent from the OD software - Im wondering if this is due to the Gmail account or an internal OD issue

I have temporarily deleted the gmail account but it has still not reduced the file size, the reason I ask this as I do a regular online backup to dropbox and each time this 1.5 GB file becomes annoying

Thank you in advance

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Over inflated EmailMessage.MYD

Post by jsalmon » Tue Apr 22, 2014 5:53 pm

It's definitely a record of all emails sent from Open Dental and we recently added an email "inbox" feature which if I remember right uses the same table as well. It very well could have downloaded all your emails from Google if you started using that feature. I'm going to bring this concern up in our next meeting.

Just as an FYI, someone else must have stumbled upon this problem as well because a feature request was recently made to be able to delete multiple emails at once. Request #3277
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Over inflated EmailMessage.MYD

Post by jsalmon » Thu Apr 24, 2014 11:27 am

I convinced our COO to treat feature request #3277 as a bug for v14.2. I'm going to add it to our bug tracker soon.
http://opendentalsoft.com:1942/ODBugTra ... sions.aspx
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Over inflated EmailMessage.MYD

Post by jsalmon » Fri Apr 25, 2014 2:21 pm

Fixed and will be released with v14.2.9.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply