Em Terça 11 Novembro 2003 13:25, Dave Logan escreveu: > Hey all, I do a direct database search because I use weDBmail (which talks > directly to the DB). There are ~ 145000 messages in my db total, about > 20000 of which are spread across my 12 folders. So when I do a search, > you have to take that all into account. I just ran a search, and got my > results in about 4.5 minutes (a little longer than I was hoping). That's > on my Sparc Ultra5, running Debian stable on mysql. I'm sure it could > be optimized, but I'm just throwing the info out there for you. > dave
Options: since you are connecting directly to the db, just create function in any language you use (php,java) to populate a attachment table every time the user login, with the messages flagged as unreaded. Since it will scan only the newest entries, it will be always fast. How many emails can you receive from one login to another? fifty? anyway, I think the problem is the way how you construct the message and decode the mime. []s, gandhi -- Ricardo Andere de Mello Quilombo Digital - Presidente [EMAIL PROTECTED] - 55 11 32717928
