I don;t know but.. I think it is because they were added later, and we generally like to avoid changing the datamodel in ways which aren't backwards compatible.
If we change the datamodel we should provide a migration script for upgrades, need to either release db alter-table & update scripts or a whole export-drop-create-import cycle. Could you improve things using better indices? a 1-1 relationship shouldn't be less efficient than a big table if the foreign keys are properly indexed. d. On 3/12/07, robert burrell donkin <[EMAIL PROTECTED]> wrote:
i've been experimenting with indexes recently. so, i've spending some time going though SQL logs looking for table scans. there are a lot of joins from message to message_flags which result in unnecessary full table scans. i think that message and message_flags are joined one-to-one. this is inefficient. is there a good design reason why message and message_flags are separated? robert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
