On 4/28/2003, "Robert L. Tom" <[EMAIL PROTECTED]> wrote: > >I applied these to my dbmail 1.1 mysql database.. > >Optimizing your tables >----------------- > > > >I found dbmail to become increasingly useless without additional >indexes. Speed increases as dramatically as server load drops >after adding these.
I need to do some looking at the actual queries, but I think many of these should be compound indexes on multiple columns for speed. For example, I would think using 1 index that matched mailbox_idnr and status would be more useful than two separate. I'll need to play with the planner in Postgresql though. Chris -- | Christopher Petrilli | [EMAIL PROTECTED]
