Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,453

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 Tweet

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.

Donate with
PayPal
Square Cash Shop at amazon
as an LGF Associate!
Recent PagesClick to refresh
Why Are So Many Queer Girls in Juvie? The findings come out of years of research done by Angela Irvine and Aisha Canfield for the National Council on Crime and Delinquency (both now work at Impact Justice). For this particular statistic, they anonymously surveyed 1,400 girls in ...
Birth Control Works
11 hours, 41 minutes ago
Views: 145 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
North Carolina Televangelist Indicted on Charges of Tax Crimes Coontz, 50, is described on his website as a "pastor, evangelist, television host, author, humanitarian, philanthropist, businessman." "a 2011 BMW, a 2011 Regal 2500 boat, a 2012 BMW convertible, a 2011 Lexus, a 2011 Land Rover, a 2006 Ferrari, ...
Tarkloon
1 day, 8 hours ago
Views: 244 • Comments: 1 • Rating: 2
Tweets: 1 • Share to Facebook
Shares: 1
Comments: 1
: 1
Isaac Asimov’s Best Arguments of All Time, Part One ➤ #Subscribe: goo.gl➤ Facebook: goo.gl➤ Twitter: goo.gl➤ Google+ : goo.gl➤ Site: goo.gl➤ Thanks for watching :) #Sciencetoday is channel uses for #education, #teaching, #review, #commentary, or research... If you have any issues with content, please contact us, for an ...
Tarkloon
1 day, 9 hours ago
Views: 196 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
AWOLNATION - Hollow Moon (Bad Wolf) (Official Video) AWOLNATION's official video for "Hollow Moon (Bad Wolf)". Watch the new AWOLNATION video Run (Beautiful Things) - From AWOLNATION’s new album, ‘RUN’, available now at:iTunes - smarturl.it CDs, Vinyl + Bundles - smarturl.itGoogle Play - smarturl.it Stream ‘RUN’ on ...
Tarkloon
1 day, 9 hours ago
Views: 165 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Judge Fines Kris Kobach $1K for Misleading Court on Materials He Brought to Trump Meeting Just another GOP liar, it's all they know how to do. WICHITA — A judge has fined Kansas Secretary of State Kris Kobach $1,000 for misleading the court about the contents of materials he was photographed taking into a ...
Tarkloon
1 day, 13 hours ago
Views: 391 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 1
Comments: 2
: 1
Bernie and Jane Sanders, Under FBI Investigation for Bank Fraud, Hire Lawyers Sen. Bernie Sanders, I-Vt., and his wife, Jane Sanders have hired prominent defense attorneys amid an FBI investigation into a loan Jane Sanders obtained to expand Burlington College while she was its president, CBS News confirms. Politico Magazine first ...
Tarkloon
1 day, 15 hours ago
Views: 305 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0
Illinois Bishop Decrees No Communion, Funeral Rites for Same-Sex Spouses : The Two-Way : NPR A Catholic bishop has instructed priests in his central Illinois diocese to deny communion, last rites and funeral rites to people in same-sex marriages – unless they repent. In the decree he sent to priests, deacons, seminarians and staff ...
Birth Control Works
1 day, 17 hours ago
Views: 401 • Comments: 3 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Tank and the Bangas - ‘Boxes and Squares’ (Live at WFUV) wfuv.org • Follow @wfuv: ow.ly Tank and The Bangas performs "Boxes and Squares" live in Studio A. Recorded 4.25.17. Host: Rita HoustonAudio: Chris RussoCameras: Brian Gallagher, Joanna LaPorte, Jiyoon Seo & Ashton Kim Editor: Joanna LaPorte & Brian Gallagher ...
Tarkloon
1 day, 21 hours ago
Views: 299 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Vince Giordano and the Nighthawks - ‘I’ve Got Rhythm’ (Live at the Cutting Room)wfuv.org • Follow @wfuv: ow.ly Vince Giordano and The Nighthawks performs "I've Got Rhythm" live at The Cutting Room. Recorded 3/22/17. Host:Audio: David SchnirmanCameras: Sabrina Sitton, Michael Sperling and Joanna LaPorteEditor: Joanna LaPorte
Tarkloon
1 day, 21 hours ago
Views: 237 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Jupiter: Juno Perijove 06 NASA / SwRI / MSSS / Gerald Eichstädt / Seán Doran Original video: Free 125 megapixel Jupiter Print Portrait: flic.kr Follow my Twitter for updates: @_TheSeaning More Jupiter here: flic.kr More stuff here: flickr.com Music by Ligeti Soundtrack: amazon.com ...
Tarkloon
2 days, 5 hours ago
Views: 286 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0