Page 1 of 1

DB data size

Posted: Fri Sep 05, 2008 3:34 am
by V Suite
Jordan,

Did the database become leaner between 5.6.36 and 5.8.5? - Eliminated tables, etc? My backup strategy is to zip the directories daily (no pictures). Normally the zip size increases gradually every day, and jumps on upgrading. This time it fell 4-5%. Great work either way.

Actually, come to think of it some data was lost in conversion: The Message History was wiped. Any idea why that would happen?

Cheers

Re: DB data size

Posted: Fri Sep 05, 2008 7:27 am
by jordansparks
You're talking about the signal table
http://www.open-dent.com/OpenDentalDocu ... xml#signal
We made a drastic change to the ITypes column, which stores the kind of signal. This will allow us to have much more fine-grained signalling. Most signals are relevant for about 5 minutes, and then they are simply clutter. I have to admit that I forgot that someone might actually be using text messaging, or we would have preserved the text. This was a one-time event to provide more flexibility in the future.

Re: Signal Table

Posted: Sun May 02, 2010 10:42 pm
by V Suite
Jordan,

What kind of data is in the signal table please? You said elsewhere, "the signal table, which handles the message buttons and appointment screen refreshes." What do you mean appt screen refreshes, etc. I take it most of the signals here are internal OD signals that the user would never need to know about?

Thanks.

Re: DB data size

Posted: Mon May 03, 2010 6:07 am
by jordansparks
Right. They are interenal signals that tell OD when to refresh certain tables and screens. They do also handle the light buttons and messaging system that's found in the manage module. So if you use that messaging system, clearing the signal table will clear those messages. Usually those messages are obsolete within a day, at least for most offices.