The warm tones of FFF.NET 2.0
POSTED BY: Haken
UPDATED: Tuesday, July 31, 2012 13:12
VIEWED: 28393
PAGE 5 of 7
Quote:
Originally posted by sab39:Quote:
Originally posted by SigmaNunki:
The real question here is not, would it improve performance, because that is clearly a yes.
That sounds like it should be intuitively true but it really isn't with a decent database system. The problem is that too many people are under the illusion that MySQL is a decent database system... including Slashdot.
Right now, according to Haken, FFF.net has 3/4 of a million records. To think that accessing that, even with good indices, will take a good chunk of time longer than a DB with a couple thousand is pretty far out there.
Every DB has its critical number of records before it starts to slow down. MySQL is in the single digit millions (last time I checked, which was a while ago... and I forget which DB type it was...). Also, just lumping MySQL in one heap is somewhat dishonest as it has several different DB types.
Quote:
Originally posted by sab39:
If performance can be improved by putting stuff in a different file then *the database server does that for you transparently behind the scenes*. If you have to do extra work to migrate data back and forth, that can *hurt* performance just as easily as help it.
I said exactly nothing about moving stuff "back and forth." I suggest you re-read my post.
Quote:
Originally posted by sab39:
I work with SQL server and it does a decent job of this even with pretty big tables. Admittedly I don't think I have anything with as many records as FFF would have, but on the other hand I have done some pretty insane joins over tables with hundreds of thousands of rows and they work okay.
Haken has said recently that his SQL server was having problems with SELECT. So, things aren't running as smoothly as you think they are. In fact, SQL server has regularly been the source of problems here e.g. it couldn't handle the number of requests.
He also mentioned that he is going to throw better hardware at the problem when he gets the chance. I'd prefer a more elegant solution. But, that's just me and this ain't my site.
Quote:
Originally posted by sab39:
In my experience, the better way to get decent performance is to have a really really fast connection between webserver and database, and some in-memory caching of the results of recently-used queries.
As I recall, Haken mentioned that the DB and web server are on the same box. And even if they aren't, he's also stated that the site is run on older hardware. I don't know how much older (I still have a P166 lying around), but it's older.
I think you're forgetting that this is a home project and not a work one. Resources tend to not be as readily available at home.
----
I am on The Original List (twice). We are The Forsaken and we aim to burn!
"We don't fear the reaper"
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
Brilliant work HAKEN. I think you're right to reflect the source material. It's harmonious. I never had issues with the old look particularly, but this is a great new angle.
Thanks
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
I wasn't sure about things when I first came on (what can I say, I'm a traditionalist 
) but the more I look around, the more I like things. I think all the best things about the old site have been preserved here, and the colors really do give one a warm feeling.
**************************************************************************
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
The new site looks fantastic! Truly fits the spirit of the show.
My only concern is that, now that UBB tags are required for URLs, images and video (Hulu tag! Yay!!), are we gonna have to go through all our old posts and add the tags? A daunting task for me, as I'm a Link Whore!
But I love that we'll be able to attach links to text now! Saves so much room! 
________________________
"Spry for a dead fella!"
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
Love the new colour scheme! I always thought the black and blue was a bit alliance-y. It will probably take me a goodly while to get used to the new layout though!
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
Warm and shiny.
RWED MIA?
NOTIFY: N | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
More banners for http://beta.fireflyfans.net GO AHEAD AND CLICK to see existing banners.
The Sky by David Metlesits http://davemetlesits.deviantart.com/art/The-sky-162576408 
by Maarten Jacobi www.fireflyfans.net/sunroomitem.asp?i=5602
by Maarten Jacobi www.fireflyfans.net/sunroomitem.asp?i=4245
by Maarten Jacobi www.fireflyfans.net/sunroomitem.asp?i=6318
by Maarten Jacobi www.fireflyfans.net/sunroomitem.asp?i=5224
The Joss Whedon script for "Serenity", where Wash lives, is
Serenity-190pages.pdf at www.mediafire.com/two
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
Those look absolutely excellent and the third one down matches the color scheme of the beta sight. Well done!
------------------------
I pray for one last landing,
on the globe that gave me birth.
Let me rest my eyes on the fleecy skies
and the cool, green hills of Earth.
http://www.blogiversity.org/blogs/dmi/default.aspx
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
All warm and shiny.
And you're using my wallpaper.
Love that galley.
bun
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME
Jayne is just too damn tall in a banner from Feb 15th that I made. His head gets cut-off by the “Sign Up | Log In” that is pasted over the upper corner of beta.fireflyfans.net/banners/banner_16.jpg
The original banner:
Below, I have redone that banner and put the shortest crew member in Jayne's place -- River.
The new and improved Beta banner is made from Kristèle Pelland's "Big Damn Heroes" http://kristele.deviantart.com/gallery/#Everything-Joss-Whedon
The Joss Whedon script for "Serenity", where Wash lives, is
Serenity-190pages.pdf at www.mediafire.com/two
NOTIFY: Y | REPLY | REPLY WITH QUOTE | PERMALINK | TOP | HOME