On Nov 29, 2007 6:33 PM, Robert Burrell Donkin <[EMAIL PROTECTED]> wrote: > On Nov 29, 2007 5:20 PM, Bernd Fondermann <[EMAIL PROTECTED]> wrote: > > Robert Burrell Donkin wrote: > > > the current table structure is inefficient. MessageRow uses a > > > composite key. this is not only slow to look up but also means that > > > all relationships use two keys. MessageFlags contains only booleans, > > > is frequently queried and is related to MessageRow by a one-to-one > > > association. this structure creates many slow and unnecessary joins. > > > > > > i propose to move the flags data from MessageFlags to MessageRow and > > > remove MessageFlags > > > > > > though UIDs may not be unique across mailboxes, i think that it should > > > be possible to use a calculated PK. each UID must be less than 32 bits > > > so longer (64 bit) primary keys could be used with the high bits > > > filled by the mailbox id and the low bits by the uid. > > > > > > opinions? > > > > sounds pretty ok for me. > > > > > > > > if the table structure is changed then upgrade scripts will be needed. > > > > really? I thought the Torque stuff was only covering unreleased code. > > i'll put that another way. i'm going to need upgrade scripts. i think > it'd be a good idea to make them available to users. how?
UPGRADE.txt, svn:main/sql/upgrade/..., anything you like. Bernd --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
