Paul J Stevens wrote:
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

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,
);

Sorry if this is a dumb question but...

Is the envelope the information that most mail clients be they Squirrelmail or Thunderbird or other use to display the list of email messages? Or is the envelope something special? Couldn't we just pull all this data dynamically from the list of other cached headers and not need to make yet another copy of the same data?

Reply via email to