This is my development enviroment:
CPU: 2 cores, 2.4 GHz
OS: Debian Squeeze
apache2 APC ON
MySQL (InnoDB 8M cache)
Here’s what happens:
We’ve just inserted test data to a table (3500 rows) and, when calling that data from a datatable in yii, we get an apache process consuming 100% CPU for over 30 seconds; just after that, the render is completed.
APC is working just fine according to my apc.php, all my MySQL tables are well indexed and I’m running out of ideas on what else to do; Is there anything I’m missing?
Ty all in advace,