Here are a few things that may help:

1. ob_start("ob_gzhandler"); - gzip's script output. The only problem is that it's incompatible with ancient browsers also it can be an issue if your server doesnt have a lot of cpu power.

2. zend optimizer. nuff said.

3. http://apc.communityconnect.com/. for debian users 'apt-get install php4-apc'. An alternative to zend cache and free as in beer.

4. If using postgres implement stored procedures/views etc.

5. Don't rely on tony to speed your hardware up he's not a magician, invest in new gear or look into hosting packages with more power.

-- matt

--matt

CREATE INDEX stories_tid ON stories(tid(20))

FYI, I don't think you'll see major performance issues with Geeklog until you get a lot of data in your database. I'll be researching more indexes that might help.

Ok, this one is a bit more complicated but this ended up saving me .7 of second. I wanted to analyze all the SQL queries being executed by Geeklog to see if anything would stand out at me. To do this I created a simple table called sql_queries with two fields: 1) sql_id (auto increment) 2) sql_query (the actual sql executed) . I then added a mysql_query call to mysql.class.php to insert all sql in the table and what I found was a bit of a surprise.

The following SQL query was executed 53 times:

SELECT ug_main_grp_id,grp_name FROM group_assignments,groups WHERE grp_id = ug_main_grp_id AND ug_uid = **my_user_id**;

Obviously that alarmed me. I found out the culprit was SEC_inGroup() in lib-security. That function is called all over the place and it calls itself recursively compounding the number of SQL queries. I then noticed that the function above it SEC_getUserGroup() could be called once early on for the user and could server as a sort of cache for SEC_inGroup. So to fix this in lib-common.php after this line:

$_RIGHTS = explode(',',SEC_getUserPermissions());

I added this: // Cache the groups this user belongs to (saves us time later) $_GROUPS = SEC_getUserGroups($_USER['uid']);

The I changed SEC_inGroup() to use $_GROUPS like this.

Now that query only gets executed once! If you need to have the performance gain now then great, you can edit the files accordingly. Needless to say this enhancement will be in 1.3.1