She just... she just did the math.

Kaylee ,'Objects In Space'


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.

To-do list


Jesse - Mar 11, 2004 2:27:43 pm PST #6674 of 10000
Sometimes I trip on how happy we could be.

I'd say that (a) like liese said, we're waiting and seeing, (b) putting a show's name in the site description does not have any direct relationship to a spoiler thread, and (c) these are bureaucracy conversations, anyway.

edit: har. I typed here before reading Bureaucracy, too!


Aims - Mar 12, 2004 12:53:02 pm PST #6675 of 10000
Shit's all sorts of different now.

There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.

Okay, where the $$&#&(@#& are the developers?

2:52 in Minearverse and then 2:53 in here.


Elena - Mar 12, 2004 10:48:21 pm PST #6676 of 10000
Thanks for all the fish.

Ah, it's the oddest thing - I have no buttons. No post button, no log in button. But I've been having a graphics problem all night so maybe it's me.

Or maybe you are all conspiring against me...

(I'm going to attempt to post this by clicking randomly at the botton of the posting box in hopes that there is a hidden post button. Otherwise, you will be unable to read this.)


DXMachina - Mar 13, 2004 1:49:49 am PST #6677 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.

(Pssst, nobody tell her.)

Oh... Wait...

Ahem...

That has happened to me occasionally, and yes, it's that the browser isn't downloading the graphics. When it happens to me, it's usually because I'm running BitTorrent, which sucks up a lot of internet connection resources, preventing things like graphics and style sheets from getting through.


Elena - Mar 13, 2004 1:27:17 pm PST #6678 of 10000
Thanks for all the fish.

I think it was LJ that buggered me up. Things are fine now.


Liese S. - Mar 13, 2004 1:51:28 pm PST #6679 of 10000
"Faded like the lilac, he thought."

Hey, would a mailing list work for deathmatch notifications, or is that a less immediate medium for most people?


DavidS - Mar 13, 2004 5:23:03 pm PST #6680 of 10000
"Look, son, if it's good enough for Shirley Bassey, it's good enough for you."

Hey, would a mailing list work for deathmatch notifications, or is that a less immediate medium for most people?

I don't think that'll work. I'm trying to think of a cheap and dirty hack that would alert people. Like a little red graphic that would pop up if you got more than 20 posts in Quotables in an hour. Just a simple visual that would alert people that It's On.


§ ita § - Mar 14, 2004 12:08:10 pm PST #6681 of 10000
Well not canonically, no, but this is transformative fiction.

Last round of code volunteers gave us PMM, Jon [little SQL], Liese [limited].

We need to sift the code over to investigate streamlining page delivery.

There are a couple options -- pooling MySQL connections (requires little code change, and diligent MySQL tuning -- therefore not applicable if we want to change to a non-dedicated host); changing DB backends (to something more sophisticated, like PostGres, which would require changes in the class files, and somewhat limits the hosting choices we'd have, but not severely); fixing MySQL (I wish); redoing the existing SQL, keeping the back end and default tunings.

Personally, I'm pro the Postgres route, because it's transaction oriented, and can do stored procedures and triggers.

But I'm out of pocket until early April, for sure.

This is something that should be resolved one way or another so we know our future. I'm not sure how much cash we have in pocket for hosting, but we can't stay here forever unless we know we have to.


Jesse - Mar 14, 2004 12:09:40 pm PST #6682 of 10000
Sometimes I trip on how happy we could be.

We're good through the end of the year, money-wise. (Because people ROCK, have I mentioned that?)


Liese S. - Mar 14, 2004 12:56:53 pm PST #6683 of 10000
"Faded like the lilac, he thought."

With pooling connections, would that be something we could do up and tweak over here, and have it work when we moved to a cheaper solution? Or would it need continual tuning?

From what I've seen of the code, other than pooling connections, I'm not really seeing a whole lot of major improvement just sitting out there. Obviously, there could be a lot I'm not seeing, but it's fairly straightforward code-wise. We're just (like similar applications) high on transactions, since every part of the page is delivered on demand.

I'm not too opposed to switching backends, though that's probably the most labor-intensive option on the table. Don't know about PostGres specifically, but that doesn't matter (me not knowing it, that is).

Since it seems like our problem is specific to mySQL, switching backends may be the best option.