I always think of the pharmacy chain, myself.
I think of the pharmacy chain, and then I think of my little sister's initials. Unfortunate, that....
t /last natterer
Spike: Taking up smoking, are you? Harmony: I am a villain, Spike. Hello!
Spike/Harm ,'Help'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Rebecca Lizard - Mar 02, 2003 1:03:25 pm PST #3310 of 10000
You sip / say it's your crazy / straw say it's you're crazy / as you bicycle your soul / with beauty in your basket
amych - Mar 02, 2003 1:04:36 pm PST #3311 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
</last natterer>
t that's what you think
§ ita § - Mar 02, 2003 1:57:38 pm PST #3312 of 10000
Well not canonically, no, but this is transformative fiction.
Hey! Guys!
Take the natter to Press!
Connie Neil - Mar 02, 2003 1:58:33 pm PST #3313 of 10000
brillig
evil ita. Someone touch her, make sure she's real.
John H - Mar 02, 2003 1:59:20 pm PST #3314 of 10000
Did CVS get crossed out because it's set up?
Am I listed as a wannabe Developer? Is there a mailing list?
§ ita § - Mar 02, 2003 2:08:27 pm PST #3315 of 10000
Well not canonically, no, but this is transformative fiction.
Dare you to touch me ...
John, there is a mailing list, you are on it, it's inactive.
We're waiting for Karl to have enough free time for a CVS setup. But really, we don't need to. The top of the list is here: Am-Chau Yarkona "Buffistas Building a Better Board" Jan 31, 2003 10:59:28 am EST
Am-Chau, can you post the whole thing when you come by?
Some of these we need to hash out specs for -- my thinking, for example is that the search function should:
- show no more than 20/page
- show the thread name if invoked from a thread page
- default to the smallest scope
- allow sorting by date or by thread
- list the thread from which each result comes
MARCIE also needs to be specced.
John H - Mar 02, 2003 2:17:28 pm PST #3316 of 10000
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?
John H - Mar 02, 2003 2:17:57 pm PST #3317 of 10000
there is a mailing list, you are on it, it's inactive
Forgot to say, thanks.
§ ita § - Mar 02, 2003 2:22:55 pm PST #3318 of 10000
Well not canonically, no, but this is transformative fiction.
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).
John H - Mar 02, 2003 2:28:27 pm PST #3319 of 10000
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?