What's the size of the source file it pulls from? I was told that a non-SQL solution for a similar volume would be slower, since it's all file reads, whereas the SQL solution would use more RAM caching.

It's just a plain txt file, so it's as big as it needs to be. Dunno if speed would be an issue or not. Check it out here.

It's not so much a speed issue, as a tapping other resources issue.

Can you e-mail me the code? I am leaning, however to the cronned QotD -- I just have to think it out, and find out what command line options we have with this account.

My tuppenorth - I think we should make all endeavours to stay with IH. We ain't going to get such good, personal, and funny support as we do from kristen. If we have to ditch quotes, so be it.

Deena-

What I do is just keep hitting read new at the end of every page I am reading. I don't know if this is better or not.

I never quite understood the value of the message center.

Do you read every single thread? I don't (fanfic for instance). The message center displays only those threads to which you're subscribed. It removes some of the clutter. Using message center won't help the sql resource issue. It might, however, make your experience on the board friendlier.

Deena-

What I do is just keep hitting read new at the end of every page I am reading. I don't know if this is better or not.

This is only going to be good for you Deena (in a personal sense) if you only subscribe to the threads you always want to read. If you subscribe to threads you only sometimes read when things are slow, you're going to get in there with the read new function, whether you choose to, or not.

Thanks everyone. I tried Read New, but I ended up being in threads I didn't expect to land in and not realizing it at first and, when I have time (which doesn't seem to be a commodity right now) I like to catch up in the threads I don't regularly read. I think the only threads I don't at least skim every once in awhile are Farscape and Due South.

But what we can't provide, as far as I know, are links to independent bookstores and music stores.

Actually, I imagine we could by doing a little digging. For example, Powell's has a program. What we might not be able to do (or, per amych's post, maybe we could) is promote small local stores or even small chains that can't afford partnerships.

OTOH, it sounds like, with a little tinkering like QOTD and possibly increasing the default number of posts (to 20?), we aren't likely to need our own server for a while. So for now, we can probably keep it at the loose talk level.

(Edit because I screwed up a link.)

We can sell banner ads, too, if raising money is what we're after. But the idea of Amazon and other retailer ads on our main pages gives me a serious wiggins.

t shudder

Me too. I was envisioning a corner of the site, tucked away under a single word link (like Buffiliates) that if clicked would bring up a page of just shopping links for those people who do a ton of online shopping anyway (like me), to help raise money for the cause. But banner ads and pop ups would be horrible.

A banner ad to Amazon doesn't bother me, because plenty of us talk about what we've ordered on Amazon, and what's in our gold boxes, etc., at least a couple of times a week. To me, it's capitalizing on word-of-mouth advertising that we already do.

Pop-ups? No. I'll give not only money, but blood, to avoid pop-ups, but I don't think anyone has suggested them, Wolfram. We already link to Amazon in a quiet spot, and the point has been made that people forget to use the link.