Site Is So Slow!

[eluser]dmorin[/eluser]
As others have mentioned, unless your pretty familiar with MySQL, this is going to be difficult to work on. The first thing I would recommend doing is on your development machine, preferably with the production data, enable the profiler by adding the following somewhere so it will be included on every page:

Code:

$this->output->enable_profiler(TRUE);

For example, if you're autoloading any of your own libraries, put that in the constructor of the library and it will be included on every page. Then, browse the site and look at the bottom of the page to see the profile for that page. This will tell you how long SQL queries are taking and point out any other issues. Post back with that data and we can go from there, most likely with optimizing queries.