One query on XtroCMS Index Page!
February 28th, 2005, 03:07 am
I thought of another way to do caching in XtroCMS which involves putting cache information in the users session. If any of you have looked at XtroCMS’s code then you know that I handle sessions using PHP 4 session methods but I have custom measures in place so that it writes the data to a table within the database. (this is so that I can query how many users are on the site). I was talking to Josh of VGProjects about caching and they said they were going to cache information in the session. I didn’t really think anything of it at the time but the other day it hit me. I could put cache the queries that are loaded for the one user on every page! Now that I have that implemented and all of the caching is done, the administration index page of XtroCMS only executes one query to the session table.
Most of you are probably wondering what the big deal is. Well, every query to the database takes time. The less you have to do, the faster your script will run. Speed is one thing that I really want XtroCMS to stand out in.
The Auth system is almost fully in place now. Things are going really well. So far I am really happy with how XtroCMS is looking. Those that choose to use XtroCMS I think will be very impressed. But then again, everyone probably says that about their own scripts. 
By MHobbit on March 2nd, 2005 at 10:38 pm
Excellent, I want to try XtroCMS soon.
By Fusion on March 27th, 2005 at 11:21 am
Hello from a fellow developer (cf. my url) -
Question: are you saying that you are using your own session_set_save_handler(…) to store session info in a DB table, and now you are storing more information as a blob or what not?
If so, how do you handle the horrible ‘rotating sessions’ that some IE generate? (I’m refering to IE creating several sessions during what should be the normal lifecycle of ONE session)
-Chris.
By Suetan on January 30th, 2007 at 11:18 am
Are you still doing the developement of this?