Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,389

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
STEALTHING: the Growing Movement of Men Who Secretly Remove Condoms During Sex Two years ago, a 19-year-old Florida teen posted a call for advice in the subreddit askgaybros. In the post, he said he met a guy on Grindr and went back to his place to hook up. When the guy ...
Birth Control Works
39 minutes ago
Views: 89 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Trump-Free Sunday Mornings-Daily Beast We think it’s time to go on a more balanced Donald Diet—call it a Sabbath for sanity. And that’s why we’re going to embark on a new experiment: Trump-free Sunday mornings. Barring major breaking news, for a few hours ...
Unshaken Defiance
9 hours, 40 minutes ago
Views: 137 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 3
Comments: 0
: 3
Video: John Muir - The Last Oasis John Muir - The Last Oasis is a short film directed by Michael Coleman a Martinez, California native inspired by the writings of naturalist, author and early advocate of wilderness preservation John Muir. Many of the locations featured in ...
teleskiguy
20 hours, 47 minutes ago
Views: 295 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Woman Who Saved Lower Manhattan From Becoming a Highway What makes a city? It's not the buildings (skyscrapers) or the streets (traffic), or the banks and government offices and shopping districts sandwiched between them. It's the people. This is obvious nearly to the point of tautology, yet in ...
Birth Control Works
1 day, 4 hours ago
Views: 255 • Comments: 2 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Domestic Violence Shelters Make Plea for State Budget Resolution A group of domestic violence shelter representatives and other human services advocates gathered at Mutual Ground's headquarters in Aurora Wednesday morning to again make a plea for a resolution on the state's budget crisis and to call attention to ...
Birth Control Works
1 day, 6 hours ago
Views: 170 • Comments: 1 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
This Wasn’t the First Act of ‘River Piracy’ to Affect the Yukon’s Biggest Lake Image: Kluane11.jpg Author: Dermot Cole, Alaska Dispatch News Canadian geologist John Clague, whose research on Kluane Lake began in 1980, has long believed that the biggest river flowing into the largest lake in the Yukon Territory could be switched ...
Cheechako
1 day, 23 hours ago
Views: 201 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
BBC Radio 4 - Seriously… - Seriously… - 10 Women Who Changed Sci-Fi 10 Women Who Changed Sci-Fi As the Radio 4 documentary Herland examines how science fiction tackles ideas of gender in future worlds, we present a selection of great female authors who have radically altered the genre... Mary Shelley Credited ...
Birth Control Works
1 day, 23 hours ago
Views: 290 • Comments: 0 • Rating: 2
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Housing Vouchers Would Change the Face of Poverty - Vice VICE: What should every renter understand about their rights?Matthew Desmond: Rights vary from city to city, so getting to know your rights is a matter of knowing where you live, as they can actually be very fair. For example, ...
Birth Control Works
2 days ago
Views: 248 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Craig Finn - ‘Be Honest’ (Live at WFUV)wfuv.org • Follow @wfuv: ow.ly Craig Finn performs "Be Honest" live in Studio A. Recorded 2.21.17. Host: Eric HollandAudio: Jim O'HaraCameras: Sabrina Sitton, Michael Sperling, Kevin O'Malley & Alexandra ReillyEditor: Kevin O'Malley & Sarah Burns
Tarkloon
2 days ago
Views: 166 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Marvel’s Cloak and Dagger - Official Trailer Get your first look at the upcoming Freeform TV series about the two young Marvel heroes, starring Olivia Holt as Dagger and Aubrey Joseph as Cloak. Watch more trailers here! Check out the latest and greatest from IGN here! ...
Tarkloon
2 days ago
Views: 189 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0