Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,471

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
Kevin Cavanaugh Becomes First Democrat to Win New Hampshire State Senate Special Election Since 1984 BOW, N.H. (AP) — Democrat Kevin Cavanaugh has won the special election for New Hampshire's District 16 state Senate seat. Cavanaugh defeated Republican David Boutin and Libertarian Jason Dubrow on Tuesday. District 16 covers Bow, Dunbarton, Candia, Hooksett and ...
Thanos
17 hours ago
Views: 228 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Washington’s Biggest Problem Isn’t Gridlock or Wasted Dollars — It’s Men Now if I were Capito, I would have a very hard time not tweeting at Farenthold, “Boy, I wish you would.” Capito runs four miles most days. She could have a quick draw. Farenthold also runs well, notably away ...
Birth Control Works
20 hours, 23 minutes ago
Views: 282 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The New Respects - Come as You AreMusic video by The New Respects performing Come As You Are. (C) 2017 Credential Recordings vevo.ly
Thanos
2 days, 3 hours ago
Views: 408 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Isley Brothers, Santana - I Remember (Audio)Music video by The Isley Brothers, Santana performing I Remember (Audio). (P)(C) 2017 Starfaith, LLC and RI Top Ten, LLC, under exclusive license to Sony Music Entertainment vevo.ly
Thanos
2 days, 3 hours ago
Views: 267 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
They Kept Us as Slaves: AP Reveals Claims Against ChurchThey kept us as slaves: AP reveals claims against church SPINDALE, N.C. (AP) -- When Andre Oliveira answered the call to leave his Word of Faith Fellowship congregation in Brazil to move to the mother church in North Carolina at ...
Shiplord Kirel, live from behind wingnut lines
2 days, 9 hours ago
Views: 309 • Comments: 1 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 1
Comments: 0
: 1
Stranger Things Season II Trailer The first trailer for Stranger Things 2 is here. It’s 1984 and the citizens of Hawkins, Indiana are still reeling from the horrors of the demogorgon and the secrets of Hawkins Lab. Will Byers has been rescued from the ...
Thanos
4 days, 6 hours ago
Views: 525 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
‘Silent Coup’: Limbaugh Says ?!?! In an impassioned commentary, Rush Limbaugh said he believes the Washington establishment - both Democrats and Republicans - are involved in a "silent coup" against President Trump. Silent coup? Wrong and wrong. As silent as Rachael Maddow, Keith Olberman ...
Unshaken Defiance
1 week ago
Views: 974 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Immigration: Focus LocallyIn these days of Trump and the Republicans attacking everything decent about America, it's too easy to focus on the immediate threat. Trump's Muslim band is back, but everyone is paying attention to the Republicans trying to steal our healthcare. ...
jhncsy
1 week, 1 day ago
Views: 721 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
‘Submit to Your Husbands’: Women Told to Endure Domestic Violence in the Name of God (Australian Broadcasting Corporation) The culprits were obvious: it was the menopause or the devil. Who else could be blamed, Peter screamed at his wife in nightly tirades, for her alleged insubordination, for her stupidity, her lack of sexual pliability, her refusal to ...
Birth Control Works
1 week, 2 days ago
Views: 1,107 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
West Virginia Families, Just Learning About Health-Care Access, Fear It Will Be Taken Away - Rewire In Vienna, West Virginia—just north of Parkersburg, along the Ohio River separating the two states—the only Planned Parenthood health center in the state sits among a scattering of gray and tan buildings beside the main road. A few days ...
Birth Control Works
1 week, 2 days ago
Views: 1,101 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0