Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,271

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
Julian Assange Moves the Goalpostsnytimes.com Julian Assange skipping out on his statement he would allow extradition to the USA if Chelsea Manning were released. Done. Now, typical of malignant narcissists he moves the goalposts and now adds an open defiance of conditions only "he" ...
Rocky-in-Connecticut
45 minutes ago
Views: 30 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Titan Touchdown On Jan. 14, 2005, ESA's Huygens probe made its descent to the surface of Saturn's hazy moon, Titan. Carried to Saturn by NASA's Cassini spacecraft, Huygens made the most distant landing ever on another world, and the only landing ...
Thanos
1 hour, 25 minutes ago
Views: 58 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0
Larsen Ice Crack Continues to Open Up The rift in the Larsen C Ice Shelf has grown a further 10km since 1 January. If the rift propagates just 20km more, it will free a tabular berg one-quarter the size of Wales. That would make it one ...
Thanos
10 hours, 29 minutes ago
Views: 144 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
​Uber Pays $20M to Settle FTC Claims It Duped Drivers More rulings against GIG economy exploiters need to come down because they are draining the lifeblood from lower and middle class job sectors by exploiting labor. The contractor economy is just flat wrong. Uber has agreed to hand over ...
Thanos
10 hours, 35 minutes ago
Views: 140 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Brazilian Corruption Investigator Killed in Plane Crash You would think the people of Brazil would be hard to shock after the turbulence that they have endured in the past few years, including a deep recession, and the impeachment of a president. But today's sudden death of ...
Thanos
10 hours, 42 minutes ago
Views: 96 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
El Chapo, Mexican Drug Kingpin, Is Extradited to U.S. Joaquín Guzmán Loera, the notorious drug lord known as El Chapo who twice slipped out of high-security Mexican prisons and into criminal legend, was extradited to the United States on Thursday night, officials said, drawing to a close a ...
Thanos
10 hours, 47 minutes ago
Views: 121 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Rick Perry’s Coming Around on Climate Change?From Gizmodo: Perry was nominated for the position despite the fact that he once proposed completely eliminating the agency. The New York Times also noted yesterday that he had no idea what the Department of Energy actually does until very ...
jhncsy
10 hours, 48 minutes ago
Views: 94 • Comments: 1 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Gambia Now Has 2 Men Who Claim to Be President West African troops have crossed the border with Gambia in an effort to uphold the result of the country's presidential election by force. The winner of the Dec. 1 vote, Adama Barrow, was officially sworn in as president at ...
Thanos
10 hours, 48 minutes ago
Views: 126 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Planned Parenthood New Campaign Generation Z Videos Kids these days. They're all about their Snapchat, drones, and being cool right? Wrong. With its latest campaign, #IDEFY, Planned Parenthood is hoping to make Generation Z into a group of revolutionaries that will fight for what they believe ...
Birth Control Works
14 hours, 6 minutes ago
Views: 200 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
NYT: With All Due Disrespect -Rep John Lewis Not Attending Inauguration As you might expect, this statement provoked a hysterical, slanderous reaction from the president-elect – who, of course, got his start in national politics by repeatedly, falsely questioning President Obama’s right to hold office. But Mr. Trump — who ...
Birth Control Works
14 hours, 10 minutes ago
Views: 439 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1