How often are people getting it? I'm about one in ten ... which doesn't lend itself to the caching explanation.
I can certainly delete it.
What? I'm not allowed to hit people? Wesley: Not people capable of genocide. Angel: Those are exactly the types of people I should be allowed to hit!
'Just Rewards (2)'
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.
§ ita § - Jan 01, 2003 9:29:36 pm PST #2520 of 10000
Well not canonically, no, but this is transformative fiction.
John H - Jan 01, 2003 9:41:36 pm PST #2521 of 10000
I can certainly delete it.
I'd be interested to see if another one took it's place.
How long is it:
it's all about the coat. Host 'Judgement'
12345678901234567890123456789012345678901
it's 41 chars long.
If we delete it and another very short one starts to show up a lot, then there's a clue, maybe.
And, it's not like we don't all know that quote off by heart by now. It won't get forgotten...
Edited because 31 and 41 aren't the same thing.
Jon B. - Jan 01, 2003 9:42:39 pm PST #2522 of 10000
A turkey in every toilet -- only in America!
And we can always re-add it. I'm curious to see what happens as well.
§ ita § - Jan 01, 2003 9:43:50 pm PST #2523 of 10000
Well not canonically, no, but this is transformative fiction.
I've flipped the approved switch to "N", so it should no longer show up.
Jon B. - Jan 01, 2003 9:45:36 pm PST #2524 of 10000
A turkey in every toilet -- only in America!
A quick test brings up a lot of "We die horribly and painfully, you go to hell and I spend eternity in the arms of baby Jesus. Gunn, 'There's No Place Like Plrtz Glrb'"
Jessica - Jan 01, 2003 9:46:27 pm PST #2525 of 10000
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I just got that one on 4/7 refreshes.
[edit: And, FWIW, every time Read New has sent me to the Message Center in the past few minutes has given me that Gunn quote. Don't know if that's relevant, or just coincidence.
Betsy HP - Jan 01, 2003 9:52:26 pm PST #2526 of 10000
If I only had a brain...
And it's a Gunnathon here, too. Hmm. Plus two Mayors.
§ ita § - Jan 01, 2003 9:55:38 pm PST #2527 of 10000
Well not canonically, no, but this is transformative fiction.
It likes the first quote in the table more than it likes all the rest.
Me, I don't really care. I'll toss a seed in and see if anything changes.
John H - Jan 01, 2003 10:00:59 pm PST #2528 of 10000
I'm researching this in newsgroups, and you know how you said you didn't want to get all the rows and then throw them all away?
That's apparently what it's doing anyway.
"Gavin M. Roy" <gmr@justsportsusa.com> writes:SELECT * FROM poetry ORDER BY random() LIMIT 1;[ is slow for 35000 rows ]Yeah. Basically this query is implemented as (a) select all 35000 rows of "poetry"; (b) compute a random() value for each row; (c) sort by the random() values; (d) take the first row, discard the rest.
The good news: this gives you a pretty-durn-random selection. The bad news: you didn't really care about choosing a random ordering of the other 34999 rows, but it computed one anyway.
This problem's been discussed before, but I've not seen any really ideal answer. SQL is not designed to offer unpredictable results ;-)
§ ita § - Jan 01, 2003 10:04:37 pm PST #2529 of 10000
Well not canonically, no, but this is transformative fiction.
But the database is doing it, and so it's faster than us having to handle a PHP data structure. That's where I want the work to lie. You'd have to page through the record set a random number of times in PHP. I don't like that at all, not on each and every page.