Performance goals for Theia 1.0 stable « home
posted on 22:38 - 24 December 2010 | posted by Lev
During the past few weeks I've been doing an awful lot of code-cleanup, and optimization as I prepare to *finally* release the stable version of Theia. I've made a whole hell of a lot of progress, but I still am not to the point where I want to be before the stable release.
Though I have not experienced any performance issues with Theia yet, as I look at the numbers (database queries, memory usage and library includes) I see there is an awful lot of room for improvement.
Thus, I have come up with the following goals which I am aiming for with this big release:
- 5 (base) SQL queries per page load (when I say "base", I mean the minimum number of queries needed to just load up the basic Theia system - session validation, retrieving user info, updating online status, logging page request - specific pages may have more than 5 queries depending on the circumstance)
- 10 queries for the home page(with most features enabled)
- 2.5 MB (base) memory usage
- 3.5 MB memory usage for home page
- 35 or fewer library includes
- 45 or fewer library includes for home page (with most features enabled)
- 0.025 seconds (base) generation time (on my server)
Obviously, all of this is completely relative. First of all, the execution time I get probably won't be what the average Theia site gets since I have a wicked fast web server with little traffic.
And the query count and library includes are being optimized for use with memcache. Now while the entire system will perform a lot better, systems with memcache will benefit a great deal more. :)
Of course these numbers could always be better, but because of the massive scope and size of Theia, I think this is a really good starting point to aim for. So far things are definitely on the right track as I've managed to bring almost all of the numbers down a good deal.
I don't want to state any estimated release because I haven't been able to live up to that in the past - instead I'll just go with "it's ready when it's ready"! ;P
Related Items »
- about » How can I get Theia, and does it cost anything?
- documentation » Theia's error codes - reference guide
- download » Theia 1.0.0b1
- download » Theia 1.0.0b2
- home » Receive a free installation of Theia until the end of July!
- download » Theia 1.0.0b3
- home » Using regular expressions in mySQL queries
- bug tracker » multiple pointless queries on issue tracking
- requests » stored event data (serialize/unserialize)
- home » 100 million SQL queries in past 46 days!






