Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,144

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
I Had a Second Trimester Abortion & I Am Sick of Hearing Politicians’ Opinions About It I have been pro-choice for as long as I can remember. But by the time I was married and pregnant with my first child, I didn’t really put much thought into the idea that I would ever need an ...
Birth Control Works
2 hours, 10 minutes ago
Views: 74 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Nick Lowe-I Love the Sound of Breaking GlassNick LoweI Love the Sound of Breaking Glass (1978)
Thanos
2 hours, 20 minutes ago
Views: 65 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Breitbart Commenters See Evidence of Health Problems in Hillary’s “Shimmy” The above is a fun gif someone made of Hillary Clinton's "shimmey" last night when Donald Trump actually said he had a "winning temperment." But Breitbart commenters see evidence of serious health problems, and they toss in some misogyny ...
thecommodore
2 hours, 38 minutes ago
Views: 214 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0
Latest IoT DDoS Attack Dwarfs Krebs Takedown at Nearly 1Tbps Driven by 150K Devices If you thought that the massive DDoS attack earlier this month on Brian Krebs’ security blog was record-breaking, take a look at what just happened to France-based hosting provider OVH. OVH was the victim of a wide-scale DDoS attack ...
Thanos
4 hours, 1 minute ago
Views: 171 • Comments: 0 • Rating: 2
Tweets: 12 • Share to Facebook
Shares: 0
Comments: 0
: 0
Off-Duty Cop Who Killed Delrawn Small Indicted on Murder Charges A city cop was indicted Monday on second-degree murder charges in the road-rage shooting death of driver Delrawn Small, who was killed in a July 4 confrontation with the off-duty officer, sources said. The cop, Wayne Isaacs, will be ...
Thanos
4 hours, 5 minutes ago
Views: 110 • Comments: 0 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Gov. Christie Was Happy to Hear of Fort Lee Gridlock: Ex-Crony Gov. Christie was “happy” when he learned that gridlock had overwhelmed Fort Lee following the mayor's refusal to endorse his reelection, his former loyalist at the Port Authority testified Tuesday. David Wildstein recalled in Newark Federal Court that he ...
Thanos
4 hours, 10 minutes ago
Views: 77 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Bomb Blasts Strike Mosque, Congress Center in Germany City of Dresden BERLIN (Reuters) - Two improvised bombs exploded in the eastern German city of Dresden on Monday evening ― one at a mosque and one at an international conference center ― but no one was injured, police said on Tuesday. ...
Thanos
6 hours, 54 minutes ago
Views: 100 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Like 2016 Campaign, First Presidential Debate Defied Conventional Patterns Clinton suggested Trump was hiding something and said he may have paid no federal income tax at all. “That makes me smart,” Trump said. “So if he’s paid zero, that means zero for troops, zero for vets, zero for ...
Thanos
7 hours, 13 minutes ago
Views: 144 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Donald Trump Fell for Hillary Clinton’s Trap at Monday’s Presidential Debate The Clinton campaign’s greatest fear throughout the general election has been that some other Trump would emerge ― a more measured, reasonable and mature man, one who might look like he was ready for the Oval Office. That man ...
Thanos
7 hours, 17 minutes ago
Views: 156 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Factbox: Market Participants React to U.S. Presidential Debate JAMES ATHEY, INVESTMENT MANAGER AT ABERDEEN ASSET MANAGEMENT: "What we're seeing in markets this morning is a small, collective sigh of relief because most commentators, and the few polls that have been released, suggest Clinton won the debate. Equities ...
Thanos
7 hours, 20 minutes ago
Views: 145 • Comments: 0 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0