Indexes, smarter queries, change db engine etc. There are many more basic tools that will actually tell you some steps to take. I really suggest you go off and read some mysql books. Then you can rewritten to your database with some 'explain' commands and know what you are doing, what the results mean and what to do to fix things. alan