I think it should be something about the Chosen One.
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.
How 'bout
Buffy: I'm sorry. Am I repeat-o-girl?
for some reason the program really likes quote No. 1
Just for the record, if you're interested, we use the built-in RANDOM feature of the SQL database, and it seems to be broken in some way in this version.
That random feature is very database-intensive, because it does something like assign a different number to every row in the db, then sort them by that number. Somewhere in that process something goes wrong, and it's not just us, there are other people in newsgroups whinging about it.
It's been proposed before that we generate a random number in the PHP and fetch just that one record instead, but ita doesn't think it's worth the effort for something that's not an essential feature.
It's been proposed that you just hack it so it tries again if it comes up with that quote. Somebody second me so I'm not allowed to bring this up again for six months.
It's been proposed that you just hack it so it tries again if it comes up with that quote.
OK that's just doubly illogical. If we do something database intensive and it doesn't work, the solution is to do it twice a pageview, not once? What if it comes up with the "baby Jesus" thing again? You're going to make me wait for it to come up with an original quote, when people are reporting 6 out of 10 "baby Jesus"?
The beauty of my approach is, you note, once, how many quotes in the db, -- six hundred or so? -- you generate a random number, on load, from one to six hundred and the job's done. ita has to remember to change the upper limit when new quotes get added to the db, but as that's only ever happened once, and nobody would know if she forgot, it's not onerous.
This way we're hammering the database on every pageview in order to get something random, but we're not getting something random. It'd be more sensible to adopt one quote and stick with it...
I understand both ways I was illogical now. That's enough to make me be quiet for six months instead of suggesting easy code kludges that end up slowing down every page load and bothering the server.
Aw, don't take it that way. It's just the quote thing is a kind of specialist subject of mine.
I wanted to back down extra far because I was also pushy about Marcie just a few posts before and I probably don't know what I'm suggesting there either. My programming knowledge is limited to non-internet C++ stuff, so I mistakenly thought of the iterating as painless and the coding as one little if statement. Also I misread you about which randomization method was more database intensive.
I think it should be something about the Chosen One.
How about just the early-season opening credit thing about one girl in all the world, blah blah?
How about just the early-season opening credit thing about one girl in all the world, blah blah?
In every generation there is a Chosen One. She alone will stand against the vampires, the demons and the forces of darkness. She is the Slayer.