Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,057

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

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
Brexit in Brussels: Juncker’s Mic Drop and Political Brexploitation The three presidents—Juncker along with Donald Tusk, who heads the European Council, and Martin Schulz, the president of the European Parliament—said they “expect the United Kingdom government to give effect to this decision of the British people as soon ...
Thanos
3 hours, 31 minutes ago
Views: 104 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Brexit: EU Spells Out Procedure for UK to Leave The European Union has clarified the way the UK can kickstart formal negotiations to exit the bloc following Thursday's referendum. It says Britain can trigger Article 50, which sets a two-year deadline for a deal, by making a formal ...
Thanos
5 hours, 18 minutes ago
Views: 123 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
With Donald Trump in Scotland, Hillary Clinton Rails Against His ‘Brexit’ Response Asked about Britain's plummeting currency in a part of the nation which had voted overwhelmingly to stay in the E.U., Trump noted a money-making opportunity: You know, when the pound goes down, more people are coming to Turnberry, frankly. ...
Thanos
5 hours, 20 minutes ago
Views: 97 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Former Kansas Governors Form New Political Action Group to Oppose Brownback Four former Kansas governors and other state leaders have announced an effort to raise money to oppose policies and laws created in recent years by Gov. Sam Brownback and the Kansas Legislature. The Save Kansas Coalition, which sent out ...
Thanos
15 hours, 33 minutes ago
Views: 347 • Comments: 1 • Rating: 2
Tweets: 37 • Share to Facebook
Shares: 2
Likes: 5
Comments: 0
: 7
Cops Nab 3 ‘Vigilantes’ With Arsenal in Van at Holland Tunnel Last Week's good guys with multiple guns. blockquote>A search turned up five pistols, an AR-15 assault rifle, a shotgun, four knives, 10 loaded clips of ammunition and a military-grade helmet. Along with Smith, John Cramsey, 50, and Kimberly Arendt, ...
Thanos
15 hours, 57 minutes ago
Views: 208 • Comments: 1 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Today’s Good Guy With a Gun Teaches Us How to Open a Door With a Sig Sauer Hey, it only took two magazines to open that door. Neighbour 'Refused Him Sex' So He 'Shot the House 33 Times' Cops suspect that Sparber had become infatuated with his neighbour and after getting drunk he attempted to shoot ...
Thanos
22 hours, 17 minutes ago
Views: 519 • Comments: 1 • Rating: 2
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Turkey Guilty Verdict for Depicting Erdogan as Gollum Did you ever notice how thin skinned bullies like to silence and punish their critics? A court in the south-western Antalya province gave Rifat Cetin a suspended one-year jail sentence and stripped him of parental custody rights. He has ...
Thanos
22 hours, 46 minutes ago
Views: 240 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Britain Is Leaving the EU. Here’s What That Means. Subscribe to our channel! goo.gl vox.com is a news website that helps you cut through the noise and understand what's really driving the events in the headlines. Check out vox.com to get up to speed on everything from Kurdistan ...
Thanos
23 hours, 6 minutes ago
Views: 224 • Comments: 0 • Rating: 1
Tweets: 3 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
At Least 20 Dead as Historic Floods Sweep West Virginia At least 23 people, including an 8-year-old boy who was wading in a foot of water, died in massive floods in West Virginia from a storm system that has dumped a historic amount of rain in parts of the ...
Thanos
1 day, 6 hours ago
Views: 241 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Kindergarten Teacher Allegedly Killed by Mother-in-Law With Children Inside Home A kindergarten teacher was allegedly shot and killed by her mother-in-law with her children in the home, WSB-TV reports. Investigators were called to a home Thursday morning on a report of a gunshot wound. When they arrived, they discovered ...
Thanos
1 day, 22 hours ago
Views: 524 • Comments: 1 • Rating: 3
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0