Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,109

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.

Recent PagesClick to refresh
North Carolina Transgender Students Win Toilet Access Ruling A state law passed in March requires transgender people to use toilets that correspond to the sex on their birth certificates. The ruling led to boycotts of the state by some sports teams, businesses, and entertainers. The full case ...
Thanos
3 hours, 8 minutes ago
Views: 54 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Sovereign Sex Offender Involved in Tense KCK Standoff Arrested by U.S. Marshals Another Sovereign Citizen standoff, The original standoff lasted for more than six hours outside of a home near 57th Street and Parallel Parkway. U.S. Marshals and KCKPD originally attempted to arrest Gregory Andrews on warrants including a parole violation ...
Thanos
16 hours, 11 minutes ago
Views: 202 • Comments: 0 • Rating: 1
Tweets: 3 • Share to Facebook
Shares: 0
Comments: 0
: 0
Hillary Clinton Denounces the ‘Alt-Right,’ and the Alt-Right Is Thrilled Mr. Trump has publicly kept his distance from the alt-right, but his critics have accused him of offering subtle cues to invite its support. His appointment of Stephen K. Bannon, the head of Breitbart News, to be chief executive ...
Thanos
1 day, 1 hour ago
Views: 202 • Comments: 1 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Tim Kaine Blasts Donald Trump’s Immigration Policies as the ‘Actions of an Idiot’ Tim Kaine didn’t hold back when asked about claims that Donald Trump is softening his stance on immigration. “I don’t buy it,” the Democratic vice presidential nominee told “The Late Show” host Stephen Colbert on Thursday. “He’s always fighting ...
Thanos
1 day, 1 hour ago
Views: 309 • Comments: 0 • Rating: 1
Tweets: 27 • Share to Facebook
Shares: 4
Comments: 0
: 4
Missouri ‘Witch Hunt Hearings’ Modeled on Anti-Choice Congressional Crusade - Rewire “They say that a lot in Missouri,” state Rep. Stacey Newman (D) told Rewire in an interview at the Democratic National Convention last month. Newman is a longtime abortion rights advocate who proposed legislation that would subject firearms purchases ...
Thanos
2 days, 17 hours ago
Views: 340 • Comments: 1 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Charter Schools: Last Week Tonight With John Oliver (HBO) Charter schools are privately run, publicly funded, and irregularly regulated. John Oliver explores why they aren’t at all like pizzerias. Connect with Last Week Tonight online...Subscribe to the Last Week Tonight YouTube channel for more almost news as it ...
Thanos
2 days, 23 hours ago
Views: 332 • Comments: 0 • Rating: 0
Tweets: 25 • Share to Facebook
Shares: 3
Comments: 0
: 3
Deadly Earthquake in Italy: What We Know – The 6.2. magnitude earthquake struck central Italy, near Rieti, shortly after 3:30 a.m. local time and was followed by several aftershocks. – At least 37 people have been killed and dozens are missing, according to Italy's civil protection ...
Thanos
3 days, 2 hours ago
Views: 280 • Comments: 0 • Rating: 0
Tweets: 7 • Share to Facebook
Shares: 2
Comments: 0
: 2
EpiPen’s Steady Price Increases Masked Until Deductibles Rose The maker of the life-saving allergy shot EpiPen is the new poster child for exorbitant drug price increases, as high-profile members of Congress, doctors and consumers lash out over huge price increases since 2009. Mylan’s EpiPens are used to ...
Thanos
3 days, 17 hours ago
Views: 398 • Comments: 1 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Few Pastors Have Been Asked to Preside at Same-Sex Weddings - and No One Has Been Forced Americans United had a little fun about two months ago with the Religious Right’s claim that if marriage equality became the law of the land, pastors would be forced to preside at same-sex weddings. We produced a special website ...
Thanos
3 days, 19 hours ago
Views: 514 • Comments: 0 • Rating: 0
Tweets: 16 • Share to Facebook
Shares: 3
Comments: 0
: 3
A Tribe Called Red - R.E.D. Ft. Yasiin Bey, Narcy & Black Bear Pre-Order The Album! smarturl.itStream on Spotify: spoti.fi-Director: The Halluci NationLocation: Cape Town, SAActors: Narcy, Yasiin Bey and members of the Halluci NationProducer: The Halluci Nation--A Tribe Called Red Links:Website: atribecalledred.comTwitter: @atribecalledredFacebook: facebook.comInstagram: instagram.com--Yasiin Bey Links:acountrycalledearth.comFacebook: facebook.comTwitter: @CalledEarth--Narcy:wearethemedium.comFacebook: facebook.comTwitter: @TheNarcicyst ...
teleskiguy
4 days, 8 hours ago
Views: 649 • Comments: 0 • Rating: 1
Tweets: 9 • Share to Facebook
Shares: 6
Comments: 0
: 6