On Wed, 2003-04-02 at 03:00, Paul Stevens wrote: > Hi all, > > Being unable to move back to postgres I had to sweat it out. Not so much > it seemed: adding a sloth of indexes to the main tables solved all > performance issues I had. Using innodb I decided to add foreign key > contraints, and dbmail now feels very snappy indeed. Load now hovers > below 0.1 :-) >
Do you have a alter table statement floating around that modifies the stock table to use your indexes and constraints? I'd like to try them out. Thanks Ryan Butler ADI Internet Solutions [EMAIL PROTECTED]