On Wed, 2003-10-08 at 09:05, Ilja Booij wrote: > * extra table > There is an extra table in the database (physmessage, for 'physical > message', as opposed to virtual message) which links messageblocks and > messages. This gives us great speed up with regard to copying messages.
This will also reduce the number of insert and delete statements sent to the database, which (at least with postgresql) will help keep the files smaller and reduce the number of vacuums required. > The messages tables has been changed like this: it holds an extra > physmessage_id field. The messagesize, rfcsize and internal_date fields > have > been removed. > > the physmessage table holds: messagesize, rfcsize and internal_date > > the messageblks table now holds a physmessage_id instead of a > message_idnr This is also good as it reduces the size of what needs to be updated (inserted / deleted). > * extra column in users table > The users table now holds the column "currmail_size", which holds the > current > mailsize of a user. This prevents the calculation of the used quotum > every > time this figure is needed. currmail_size is now calculated every time > the > size of a user's mailbox changes. cool. > I've done quite a lot of testing, using the MySQL backend. PostgreSQL > should be > tested further. > DBMail 2.0 is now ready to be tested by more people to squash all > remaining bugs. I look forward to testing the PostgreSQL backend. I'll let you know if I find anything.
