Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,341

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
Seth Meyers: Is Devin Nunes Investigating Trump or Working With Him?Seth takes a closer look at the House Intelligence Committee's investigation into the Trump administration's alleged ties to Russia.
teleskiguy
4 hours, 2 minutes ago
Views: 65 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Congress Just Killed Your Internet Privacy Protections - Mar. 28, 2017 Make and assert your own privacy. It's important for us all. Oh and take names, remember who did this. The House of Representatives voted Tuesday to repeal Internet privacy protections that were approved by the Federal Communications Commission in ...
Unshaken Defiance
4 hours, 51 minutes ago
Views: 96 • Comments: 1 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
U.S. Judge Finds That Aetna Deceived the Public About Its Reasons for Quitting Obamacare Aetna executives had moved heaven and earth to conceal their decision-making process from the court, in part by discussing the matter on the phone rather than in emails, and by shielding what did get put in writing with the ...
Unshaken Defiance
8 hours, 10 minutes ago
Views: 149 • Comments: 0 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0
Tuffs Not Enuff PageThe tools of economics, science and law applied to well-known public policy issues. Where the Alt-Right and other interests sell doubt, we do what we can to construct sharp problem definitions and reach equally sharp conclusions. Evidence matters.
tuffsnotenuff
8 hours, 20 minutes ago
Views: 71 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
No, My Right to Abortion Did Not Cost Hillary the Election Yesterday, New York Times op-ed contributor and religious professor Thomas Groome popped up as the latest in a long line of bros getting it wrong at our newspaper of record about what cost Hillary the election. His take? Trump ...
Birth Control Works
11 hours, 48 minutes ago
Views: 140 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Fred Rogers Company Statement Regarding Federal Funding for Public Broadcasting For more than two generations of Americans, The Fred Rogers Company has partnered with CPB and PBS to share what Fred Rogers called an “expression of care” for children and families through broadcast and digital media as well as ...
Birth Control Works
12 hours, 7 minutes ago
Views: 120 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
What’s Missing in Our Coverage of South Sudan’s Civil War In South Sudan, a civil war has now entered its fourth year of tearing open ethnic divisions and displacing millions. Since its onset in 2013, the conflict has threatened to pave a path to genocide and has led to ...
Birth Control Works
13 hours, 44 minutes ago
Views: 123 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Faux-Science- -Inside the Academic Journal That Corporations Love - Pacific Standard A recent lawsuit against Monsanto offers a clear and troubling view into industry strategies that warp research for corporate gain. In a lawsuit regarding the possible carcinogenicity of the pesticide Roundup, plaintiffs’ lawyers suing Monsanto charge the company with ...
Birth Control Works
13 hours, 48 minutes ago
Views: 131 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Cowboy Cookies Recipe - NYT Cooking Ingredients 3 cups all-purpose flour 1 tablespoon baking powder 1 tablespoon baking soda 1 tablespoon ground cinnamon 1 teaspoon salt 1 ½ cups (3 sticks) butter, at room temperature 1 ½ cups granulated sugar 1 ½ cups packed light-brown ...
The Vicious Babushka
18 hours, 8 minutes ago
Views: 127 • Comments: 1 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Foreigners Behind California Breakup Effortssalon.com Two Brexit British operators hired to promote Cali-Divorce, Russia behind efforts on both Left and Right to break apart California. This is consistent with higher ups in the Russian Government and Military publicly stating their desire to break apart ...
Rocky-in-Connecticut
18 hours, 33 minutes ago
Views: 105 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0