[geeklog-devtalk] Sub-topics

[Tony Bibbs]

I think most of us would agree (correct em if I'm wrong) that it is 
better to grab all the data in a single query and have PHP code sort the 
data out as opposed to making subsequent requests to the DB.  All the 
bigger Geeklog sites (Groklaw, macosxhints, etc) seem to experience DB 
load issues.  I've yet to get a legitimate complaint about the web 
server load (Dirk may have received such issues).

--Tony

Steve Sloan wrote:


> Tony Bibbs wrote:

>

>> Actually, you should be able to grab all the topics in one query and 

>> then have some data structure you can organize them in for quick 

>> access.  

>

>

> That would probably be best, but I'd still like to see if it could be 

> done in SQL (that would be a Neat Hack[tm]).

>

> That brings up a question which could make for a great Holy Way: is it 

> better to load the DB server or the web server?  When, if ever, is PHP 

> slower than SQL?  Or is it better to keep everything data-related on 

> the DB side, and if that's too slow, bug MySQL for improvements?

>

> -- Steve

> _______________________________________________

> geeklog-devtalk mailing list

> geeklog-devtalk at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devtalk