Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,625

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.

Donate with
PayPal
Square Cash Shop at amazon
as an LGF Associate!
Recent PagesClick to refresh
Artificial Intelligence Is Going to Supercharge Surveillance - the Verge Donald Trump as President, Sessions as AG, a compliant Supreme Court if Trump appoints any more judges. That's the background for the following. ...These scenarios are still a way off, but we’re already seeing the first fruits of combining ...
Unshaken Defiance
1 hour, 46 minutes ago
Views: 52 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Meanwhile at USGS.gov : Partial Shutdown Due to a lapse in appropriations, the majority of USGS websites may not be up to date and may not reflect current conditions. Websites displaying real-time data, such as Earthquake and Water and information needed for public health and ...
Thanos
18 hours, 44 minutes ago
Views: 147 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Genuine Counterfeit Fake News UpdatesAn unknown source intimately acquainted with an alleged deep-cover WH shill confirms that there are four non-negotiable conditions for weeDonnieJohnnie to appear in person before the Special Counsel. weeDonnieJohnnie must be allowed to: bring his favourite Binky® Classic bring his ...
Möbiustripped
1 day, 15 hours ago
Views: 180 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Yes, Scarlett Johansson Was Calling Out James Franco in Her Women’s March Speech Addressing the 500,000 Women’s March attendees gathered in downtown Los Angeles Saturday and even more onlookers livestreaming it at home, Scarlett Johansson began her speech with a pointed barb aimed squarely at James Franco. “How could a person publicly ...
Thanos
1 day, 20 hours ago
Views: 271 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Russian Networks Pushing #ReleaseTheMemo Meme WASHINGTON (AP) — Twitter accounts linked to Russian influence operations are pushing a conservative meme related to the investigation of Russian election interference, researchers say. The purported Russian activity involves the hashtag #ReleaseTheMemo, a reference to a secret congressional ...
Thanos
3 days, 5 hours ago
Views: 251 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Shout Out Louds - ‘Jumbo Jet’ (Live at WFUV)wfuv.org • Follow @wfuv: ow.ly Shout Out Louds perform "Jumbo Jet" live in Studio A. Recorded 11.1.17. Host: Alisa AliAudio: Brian CullenCameras: Brian Gallagher, Dan Tuozzoli, Tyler Newfell, and Alexandra ReillyEditor: Tyler Newfell & Brian Gallagher
Thanos
3 days, 14 hours ago
Views: 237 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Improving the World of Sportsblog.timesunion.com Billy Joel once said, “The good old days weren’t always good, tomorrow’s not as bad as it seems.” From one native Long Islander to another let me just say, “Billy, you may be on to something.” I’m not one ...
rhoffman
5 days, 3 hours ago
Views: 374 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 1
Comments: 0
: 1
First Footage From the New Kodak Super 8 Film Camera Can't wait to get my hands on one. Probably gonna rent 'cause $2500 or more. But what a great look. One of Kodak’s goals is to make this new Kodak Super 8 camera “as easy to use as any ...
Unshaken Defiance
6 days, 17 hours ago
Views: 642 • Comments: 1 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Grandparents Say ‘God Called’ on Perris Couple to Have So Many Children The couple accused of shackling their 13 children in filthy conditions in a Perris home were deeply religious and believed God had called on them to have so many kids, according to the grandparents of the children.David and Louise ...
Thanos
1 week ago
Views: 724 • Comments: 1 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
How Russia Says It Swatted Down a Drone Swarm in Syria On the night of January 5, a swarm of explosives-laden small drones, apparently controlled by Syrian rebels, attacked two Russian bases in western Syria, the Kremlin confirmed on Thursday. Authorities claim that Russian defenses destroyed or disabled all of ...
Thanos
1 week, 2 days ago
Views: 1,007 • Comments: 0 • Rating: 1
Tweets: 4 • Share to Facebook
Shares: 0
Comments: 0
: 0