there is a mailing list, you are on it, it's inactive

Forgot to say, thanks.

We were over bandwidth limits, and we were over storage limits? And which one does the search impact on?

No, and yes, but neither is why the site got shut down. It was server load -- full text searches were being done, the posts database is HUGE, and the server restarted. This corrupted the posts table, and subsequent attempts to fix it crashed the server again. So I had to download it, fix it locally, and get them to upload it back.

So search has to be pared down, and the posts database needs to be pruned (which should be added to the list).

From the thing ita linked to:

For every row in the table, MATCH() returns a relevance value, that is, a similarity measure between the search string and the text in that row in the columns named in the MATCH() list.

which neatly answers my question.

So essentially the problem is that when you have a very large database with FULLTEXT turned on, then searches of it make the db server unstable? Scary. Also very annoying.

But we did upgrade our storage though, right? We moved to a different hosting plan?

is that when you have a very large database with FULLTEXT turned on, then searches of it make the db server unstable?

My suspicion is that the servers are badly sized, but I don't suspect much within our price range will be much better. Because the table isn't that large when you consider discussion boards, and MySQL is a decent application.

We have upgraded our storage, yes.

And if we don't go fulltext, LIKE searches will bring the servers further to its knees. Fulltext maintains a separate specialised index, so it's space intensive, but easier on the CPU.

Where does "label bookmarks" come on the list of things we'd really like to do?

We're waiting for Karl to have enough free time for a CVS setup.

Aw, crap. I've been waiting for the list of developers. I hate it when this happens.

ita, hit me. Profile addy's good.

And, did my suggestion that the

Read New | Message center | First | Previous | Next | Last | Recent

section get TITLE attributes added get noted somewhere?

ita, hit me. Profile addy's good.

You should already have these. If not, holla and I'll holla them back.

Hi John! It's good to see you.

Um, ontopicy--I like Nilly's quote.

Am-Chau, can you post the whole thing when you come by?

I can. It's big, so takes deep breath...

From highest to lowest, at minimal information level (ie, without name of requester, dates, etc):

• CVS repository
• Move search out of beta
• Rearchitect code to use XML/XSLT
• Shorten long URLs
• Tag closer
• Ability to label bookmarks
• ENUF filter
• On-board poll ability
• Searching user list by e-mail address
• Option not to show taglines
• Quickedits for tiny text,

• More tags:

• User set style: font, colour, etc (covers for visually impaired, dislike of fonts, size, and several others)
• ‘Subscribe to this thread’ link in thread header
• List of threads in ‘set profile’ be the other way around (ie, last first)
• Threads arranged by type (NAFDA, spoiler, etc.) see BbaBB 2521 for Nou’s suggestions.
• organize the geographic mailing lists and add their own page
• Add First Book and heifer.org to Links page as preferred charities
• Force Beep Me and Press to the top of Message Center
• Reverse chronological sort for Search
• Full-screen, large font compose box for impaired vision.
• Programmatic interface for submitting to Quote Generator
• work-friendly (distinctive logo/graphics only on the front page, not when reading threads)
• Pictures, either with every post or just in the profiles
• Jump to date in thread
• message system, by which private posts can be left for other member, of limited length and retained for limited duration
• tagline archival
• (optional) birthdates in user profiles, with automatic "Happy Birthday to []" displays
• Events -- give users the ability to enter an event (JM playing guitar, ASH on Leno) which will be displayed up to the relevant date
• an "Aussie counter" (or a "Backward Antipodean Counter") somewhere on the site so people don't have to keep asking.