-
assigned issue to
- changed status to open
Website is Slooooow
Issue #2
open
No description provided.
Comments (4)
-
reporter -
reporter I did some more work on ACL_model This made a difference by reducing the sql queries by another 600 queries So we went from 2100 queries to 500 :-)
-
reporter function ch() adds tooo many sql queries. Slows down the system. Removing this on user_entity->getImage() cuts down the front page queries to 199!!
-
reporter Page not found use to have 200 queries just to load the searchbox!
Now the searchbox is dynamically loaded as you type. It's a bit slower but it makes more sense to do it that way for the future.
Full Name is also cached query as well. (Clergy name causes more queries.)
- Log in to comment
Cache now improves the speed by about 20%.
It is used in the new_base_model.php and it should be easily to use by a lot of models.
It's used now in Church and Services by adding these two lines of code.
$this->_PRIMARY_KEYS = array('id');
$this->_CACHE_ENABLED = TRUE;
It still needs some work though And it would be nice to get it working on Users