Ken D'Ambrosio wrote:
> Hey, all.  I've got a bajillion e-mails in my e-mail.  (I'm using dbmail
> for archiving.)  I don't care about disk space -- I've got it to throw
> away.  But searches take close to 5+ minutes.  Any clues on indexing,
> etc., that might be appropriate?
>
> -Ken
>
>
>   
How much data are you searching through? (how big is your dbmail db?)
How much ram does the db server have?
How much ram is allocated to the db software?
Are you running MySQL or Postgres? or something else?

If MySQL, How big is your innodb_buffer_pool_size variable in my.cnf ?

SG

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to