About the search, how does it work exactly -- not in detail, but when you feed it a search query, how does it rank the answers? If I search for "porn", in other words, how does it assign a value of greater or lesser "porn"-iness to each record found?

I must admit, I'm still a little confused about what exactly went wrong to get the board taken offline last time.

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

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.