Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,546

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
South Bay Locals Named as Part of White Supremacy Group An in-depth report by ProPublica.org into the activity of a Southern California-based white supremacy group has named at least four South Bay residents including one each from Hermosa Beach and Redondo Beach. The report details how the group, called ...
Thanos
22 hours, 41 minutes ago
Views: 342 • Comments: 0 • Rating: 1
Tweets: 54 • Share to Facebook
Shares: 2
Comments: 0
: 2
New Details Emerge About Attack That Killed US Soldiers in Niger The soldiers questioned the villagers, who dragged on the discussions longer than anticipated. “It turns out that this village was a little contaminated by hostile forces,” said Aksar. “The unit stayed a little longer than expected because apparently people ...
Thanos
22 hours, 45 minutes ago
Views: 422 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Hyperloop in Missouri: Company Says KC-STL Route Top Contender An official with Hyperloop One, which proposes building ultra-fast tubular transportation around the world, said that a Missouri route is a top contender for development. Dan Katz, the head of policy for the company, told The Associated Press that ...
Thanos
1 day, 6 hours ago
Views: 165 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Sheriff Finds ‘Troubling’ Explosives, Guns, Maps and Note in Florida Home Photographs of schools, three bomb devices, guns and books on how to make explosives were found in a Dunedin man’s home Wednesday, officials report. Deputies with the Pinellas County Sheriff’s Office were executing a search warrant at 1234 Royal ...
Thanos
1 day, 7 hours ago
Views: 198 • Comments: 0 • Rating: 0
Tweets: 5 • Share to Facebook
Shares: 0
Comments: 0
: 0
Editorial: Kobach Is Desperate for Trump’s Approval Kris Kobach has been running a Trump-style gubernatorial campaign since the day he announced. From his empty insistence that there’s a “culture of corruption” in Topeka to his argument that the Legislature’s decision to repeal Gov. Sam Brownback’s tax ...
Thanos
2 days, 18 hours ago
Views: 367 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
First Aid Kit - It’s a Shame"It's a Shame" by First Aid Kit is available now: smarturl.it Production Company: Slutet är Nära / slutetarnara.se Director: Mats UddProducer: Petra KrigströmExecutive Producer: Alexandros Bakos Lyrics: genius.com Follow First Aid Kit: firstaidkitband.com facebook.com @firstaidkitband instagram.com
Thanos
3 days, 17 hours ago
Views: 427 • Comments: 2 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Jason Isbell and the 400 Unit - American Girl10/13/2017 Encore on night 4 of Ryman residency
Thanos
3 days, 17 hours ago
Views: 477 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
WALK the MOON - Headphones Get WALK THE MOON's “One Foot” and "Headphones" Instantly When You Pre-Order The New Album 'What If Nothing':iTunes - wtmband.comAmazon - wtmband.comSpotify Pre-Save - wtmband.comGoogle Play - wtmband.comMerch Store - wtmband.com Stream "Headphones" Now:Apple Music - wtmband.comSpotify - wtmband.com ...
Thanos
3 days, 17 hours ago
Views: 382 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Nightmare at PDX In all, Cristina was held for 48 hours with the jail population, though she had committed no crime. She was treated poorly, and denied medical treatment when she requested it. She had no money in her jail phone account ...
Thanos
1 week ago
Views: 905 • Comments: 0 • Rating: 3
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Meet Rhiannon Giddens, Newly Minted MacArthur ‘Genius’ As a solo artist — and, before that, as a member of the Carolina Chocolate Drops — singer-songwriter Rhiannon Giddens has made a career out of revitalizing and invigorating decades' worth of music reflecting the African-American experience. That's meant ...
Thanos
1 week, 4 days ago
Views: 1,372 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0