Matthew T. O'Connor wrote: > Paul J Stevens wrote: > >> At this point the _only_ things that trigger full message retrieval and >> parsing are: >> >> envelope >> bodystructure >> body[]<> and friends (rfc822.xxx) >> search text >> >> The first two can be optimized fairly easily, with only minimal changes >> to the delivery chain and the addition of two new cache tables. > > > I assume when Squirrelmail shows a list of messages in a folder that > it's only requesting envelope's yes? Seems like we should be able to > return that without ever touching the message bodies. Which two new > cache tables does this require?
create table dbmail_envelopes ( id int not null, physmessage_id int not null, envelope text not null, primary key (id), foreign key (physmessage_id) references dbmail_physmessages(id) on update cascade on delete cascade, ); and the same for dbmail_bodystructure... -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
