Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,029

The new LGF Pages re-design is now in launch mode, and the first thing you’ll notice is that it looks a lot like the rest of the site. And that’s a good thing.

The old LGF Pages index had its own design, which actually started as a coding experiment way back in the day. Now it’s completely integrated into the design of the rest of LGF.

It’s more than a design integration, though; I also lavished a lot of attention on the plumbing, the MySQL queries that manipulate the LGF Pages database tables. Many of these queries worked very well as long as the whole list of Pages wasn’t too large — but with the number of Pages approaching 300,000, those queries were becoming unacceptably slow. In the lingo, they weren’t scaleable. That’s why I had to take the LGF Pages index offline when we installed our new servers.

Now these queries are very scaleable; I’ve optimized and refactored the queries and the PHP code behind them to make this new version respond much more quickly — again, like the rest of LGF.

If you’re signed in to an LGF account, some of the stats displayed on LGF Pages indexes are now “live,” updated at 5-second intervals, including the last comment and the page views. The Twitter counter is updated too, but at 90-second intervals.

When you scroll all the way to the bottom of the list of Pages, there’s a big button labeled “Show More Pages.” If you’re so inclined you can just keep clicking this button and showing more Pages until you reach the end, or your browser explodes, whichever comes first.

(Disclaimer: LGF not responsible for exploding browsers.)

Individual authors of Pages have their own indexes, just as in the old version, but again they now appear in a style consistent with the rest of LGF. You can get to any author’s LGF Pages by clicking their username in one of their Pages. The URL for your Pages looks like this (giving you a personal LGF web address):

littlegreenfootballs.com

And… one of the main problems with the old LGF Pages index was the search function. Basically, it sucked, and I say that as the author. Mea culpa. The biggest reason it sucked was because MySQL doesn’t have FULLTEXT indexing for tables of the InnoDB type, but you don’t really care about that. All you care about, and I don’t blame you, is that it’s fast. And the old LGF Pages search feature was the opposite of fast.

The solution: I’ve been noticing for a while that Google is crawling the heck out of LGF, and LGF Pages often show up in Google search results almost immediately after being posted, so I used Google’s “Custom Search Engine” feature to set up a special tool that searches LGF Pages. To use the custom Google search, type your search terms into the field in the left sidebar labeled “Google LGF Pages…”

Google’s search is ridiculously fast. Damned near instantaneous, in fact. Check it out and see how it compares to the old LGF Pages search feature.

Jump to top

Create a PageThis is the LGF Pages posting bookmarklet. To use it, drag this button to your browser's bookmark bar, and title it 'LGF Pages' (or whatever you like). Then browse to a site you want to post, select some text on the page to use for a quote, click the bookmarklet, and the Pages posting window will appear with the title, text, and any embedded video or audio files already filled in, ready to go.
Or... you can just click this button to open the Pages posting window right away.
Last updated: 2016-01-01 10:29 am PST
LGF User's Guide RSS Feeds

Help support Little Green Footballs!

Subscribe now for ad-free access!Register and sign in to a free LGF account before subscribing, and your ad-free access will be automatically enabled.

Recent PagesClick to refresh
Is White Washing Really Still a Thing? (Nostalgia Critic) An interesting analysis of white washing in recent pop culture history. I gleaned a few things from this: 1- There's alot of room for improvement, but it's not as bad as it used to be. 2 - When we ...
EiMitch
18 minutes ago
Views: 21 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Donald Trump Uber Alles I am the Super Classy Donald TrumpMy lies smile and never stumpSoon I will be President Obama power will soon go awayI will be fuhrer one dayI will command all of youYour kids will pledge to me in schoolYour ...
gocart mozart
9 hours, 28 minutes ago
Views: 293 • Comments: 0 • Rating: 1
Tweets: 18 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Should It Be Legal to Resell E-Books, Software, and Other Digital Goods? "If you're going to start reselling digital goods, who would be the fool who buys the original book?" asks Martijn David, the secretary general of the Dutch Publishers' Association. "A second-hand car is not new. A second-hand book is ...
Thanos
15 hours, 35 minutes ago
Views: 231 • Comments: 3 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Swiss Mark Opening of World’s Longest and Deepest Rail Tunnel Switzerland will celebrate an engineering marvel 20 years in the works on Wednesday: the debut of the world's longest and deepest railroad tunnel. The new tunnel through the Alps is 35.5 miles long, exceeding by 2 miles the current ...
Thanos
19 hours, 35 minutes ago
Views: 227 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Dr Heimlich Saves Choking Woman With Manoeuvre He Invented The 96-year-old American inventor of the Heimlich manoeuvre has used the technique himself to save a choking woman at his retirement home. Dr Henry Heimlich said he had demonstrated the technique many times but never used it in an ...
Thanos
1 day, 11 hours ago
Views: 360 • Comments: 0 • Rating: 0
Tweets: 4 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Push for Encryption Is Losing Steam in Congress, Despite Apple ShowdownI've never been in favor of a back door, however if there's an appropriately issued warrant and the phone manufacturer retrieves the data and unencrypts it without handing the tools to the police, I do not have heartburn with that. ...
Thanos
1 day, 15 hours ago
Views: 373 • Comments: 0 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Especially for the Indy Minded, Welcome to the Election From Hell The following author really captured what I sense, what I feel, what makes me despair of this election this year. My dear friends online, I confess I am far too independent for the comfort of many around me. This ...
Great White Snark
2 days, 7 hours ago
Views: 725 • Comments: 2 • Rating: 2
Tweets: 2 • Share to Facebook
Shares: 1
Likes: 2
Comments: 7
: 10
GOP Budget Bill Would Kill Net Neutrality and FCC’s Set-Top Box Plan The proposal is the latest of many attempts to gut the FCC's authority, though it's unusual in that it takes aim at two of FCC Chairman Tom Wheeler's signature projects while also cutting the agency's budget. The plan is ...
Thanos
2 days, 15 hours ago
Views: 707 • Comments: 0 • Rating: 1
Tweets: 4 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Landmark Ruling Halts Unconstitutional Taxpayer Funding of NJ Yeshiva and Seminary In a groundbreaking victory against government sponsorship of religion, a New Jersey appellate court ruled that the administration of Gov. Chris Christie violated the New Jersey Constitution when it awarded more than $11 million to two religious institutions of ...
Thanos
2 days, 17 hours ago
Views: 587 • Comments: 0 • Rating: 1
Tweets: 4 • Share to Facebook
Shares: 2
Likes: 1
Comments: 0
: 3
Dashcam Catches Moment Riverside Officers Save Man From Deadly Leap Into Missouri River K-9 Officer Andrew Marr with the Riverside Police Department comforts a man that he and officers Eric Strong and Jeremy McKown had just prevented from jumping from the Interstate 635 bridge into the Missouri River on Monday night. Courtesy ...
Thanos
2 days, 18 hours ago
Views: 732 • Comments: 1 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0