Yep typing that message made a light go on.
Here's what I did:
Let's say there are 400 people browsing the site at once (like there is right now at 11:00 eastern). And let's say that people go to a new page three times a minute. So in one minute, the page is loading 1200 times. And each time it loads, it accesses the Online list database and figures out if the person had a dollar sign, if they have a profile, if they're a girl, etc.
So what I did is put a script on the server which creates that list once a minute. Then each time someone loads the page, they just grab the already created list off the server. So it saves accessing and parsing the data in that database about 1200 times a minute. That's a lot of extra load taken off!
And it worked like a charm. For the nerds out there, our load average at peak time is usually 7-15. Today, the highest it got was 3.8 (15 minute average).
Woot! Thank you mister first poster for dissing my forum software, you just made NS faster.
Matt