Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,720

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 Page

This 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: 2015-08-02 10:58 am PDT

LGF User's Guide RSS Feeds

Help support Little Green Footballs!

Subscribe now for ad-free access!

Recent Pages
Thanos
Crowded House - Twice if You’re Lucky (Live at Leigh 2008)
Crowded House performing an early version of "Twice If You're Lucky" at Leigh Sawmill Cafe, Sunday 24th February 2008. The song was released on the album "Intriguer" in 2010. Audio recorded and remixed by Roundhead Studios.Video taken from fan ...

2 hours, 26 minutes ago
Views: 41 • Comments: 0
Tweets: 0 • Rating: 0
thecommodore
Five Strange Arugment Being Used to Defend Kim Davis
Right Wing Watch has compiled five justifications supporters of Kim Davis have been using to defend her blatantly illegal actions. Many of them are crank theories, such as this one cited by Mike Huckabee: Mike Huckabee has been making ...

4 hours, 37 minutes ago
Views: 111 • Comments: 0
Tweets: 0 • Rating: 1
I Stand With Planned Parenthood
UNICEF: 40 Percent School Dropouts in Mideast Conflict Areas
AMMAN, Jordan (AP) -- Forty percent of children from five conflict-scarred Middle Eastern countries are not attending school, the United Nations agency for children said Thursday, warning that losing this generation will lead to more militancy, migration and a ...

1 day, 13 hours ago
Views: 187 • Comments: 0
Tweets: 2 • Rating: 1
Great White Snark
UPDATE-The Now Not So Strange Saga of the MH370 Plane Part
Just when you think this will not get any more weird... The update 9/2/2015 (CNN)Now even French investigators are convinced: The airplane debris found on Reunion Island in July belonged to vanished Malaysia Airlines Flight 370, a top French prosecutor ...

5 days, 11 hours ago
Views: 670 • Comments: 2
Tweets: 0 • Rating: 4
JmpMaster
Teachers as the Target in Schools and Media
As soon as you mention public education a barrage of soundbites and adages come flying from every corner at dizzying speed. Teachers are underpaid and underappreciated, teachers are all jaded cynics that don't care anymore, teachers are the cornerstone ...

1 week ago
Views: 550 • Comments: 0
Tweets: 0 • Rating: 0
VickieHaz
Spice Up Your Home Lighting
When many of us are in need of a new lamp, ceiling light or any other lighting application the first thing we'll do is jump in the car and head off to the nearest IKEA. This is the safest option ...

1 week ago
Views: 613 • Comments: 2
Tweets: 3 • Rating: 0
Bubblehead II
President Obama Remarks on Tenth Anniversary of Hurricane Katrina
In case you missed the NOLA Presidents speech today. President Obama Remarks on Tenth Anniversary of Hurricane Katrina

1 week, 1 day ago
Views: 535 • Comments: 1
Tweets: 1 • Rating: 1
KiTA
Vester Lee Flanagan Guns Down News Crew on Live TV, Live Tweets and Films himself doing so.
Update: The shooter filmed himself performing the act and uploaded the content to several social media accounts. It was shared thousands of times before Twitter deleted it. Twitter auto-plays the video. Today would be a very good day to close ...

1 week, 2 days ago
Views: 871 • Comments: 4
Tweets: 7 • Rating: 3
Lumberhead
Why the 2016 Republican Nomination Can’t Be Predicted Through History
This election season provides a fascinating frame to see if the polarization in politics, from Washington to the states to the public, is no different than what we have seen in the past; if the angry populism evident especially ...

2 weeks ago
Views: 980 • Comments: 1
Tweets: 0 • Rating: 4
No Country For Old Haters
Unraveling the Enigma of Nintendo’s Virtual Boy, 20 Years Later
Twenty years ago, on August 21, 1995, Nintendo released the Virtual Boy in North America. The stilt-legged tabletop gaming console, which offered a unique red stereoscopic 3D display, attempted to ride a wave of popular interest in virtual reality. ...

2 weeks ago
Views: 858 • Comments: 3
Tweets: 1 • Rating: 1