Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,318

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
SpaceX to Send Privately Crewed Dragon Spacecraft Beyond the Moon Next Year We are excited to announce that SpaceX has been approached to fly two private citizens on a trip around the moon late next year. They have already paid a significant deposit to do a moon mission. Like the Apollo ...
Shiplord Kirel
1 hour, 40 minutes ago
Views: 49 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
‘Women Are Just Better at This Stuff’: Is Emotional Labor Feminism’s Next Frontier? We remember children’s allergies, we design the shopping list, we know where the spare set of keys is. We multi-task. We know when we’re almost out of Q-tips, and plan on buying more. We are just better at remembering ...
Birth Control Works
8 hours, 39 minutes ago
Views: 116 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
Micki Piperno- La Zingara - Live at Auditorium Parco Della Musica La Zingara is a piece from Micki's latest record "Guitar Story"; you can listen to the preview on I-Tunes itunes.apple.com The video clip was filmed and produced by Tommaso Cassinis at Boogie studio in Rome. In this video Micki ...
Tarkloon
20 hours, 32 minutes ago
Views: 107 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Stranger Things 2017 : Set to Drop on Halloween 99 out of a hundred times, the missing kid is with a parent or relative. What about the other time? A love letter to the supernatural classics of the 80's, Stranger Things is the story of a young boy ...
Tarkloon
1 day, 9 hours ago
Views: 165 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Ash vs Evil Dead 2nd Season in 2017 Just days before the October 31 debut of the 10-episode series based on the Evil Dead movie franchise, the premium cabler today said the show will be back for another round. "One season isn't enough to satisfy the fans' ...
Tarkloon
1 day, 9 hours ago
Views: 166 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
LIGO Detects Gravitational Waves After a decades-long quest, The MIT-Caltech collaboration LIGO Laboratories has detected gravitational waves, opening a new era in our exploration of the universe. Read more: news.mit.edu Produced by MIT Video Productions and MIT News OfficeProducer/Editor: Bill Lattanzi Footage courtesy ...
Tarkloon
1 day, 10 hours ago
Views: 188 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
While We’re Watching the Scandals, Trump Is Dismantling the Federal Government. The rage felt by the president’s critics is real, and understandable, but it also plays into Trump’s broader agenda. His chief strategist Steve Bannon outlined that strategy this week at the Conservative Political Action Conference, describing it as nothing ...
Tarkloon
1 day, 11 hours ago
Views: 294 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Criticized by Peers, White House Counterterrorism Adviser Returns Fire "The statements made from the very beginning led me to believe that it was a prank call," Smith tells NPR. "Because he's calling me from a cellphone suggesting that he wants to talk about official business — specifically, elevating ...
Tarkloon
1 day, 13 hours ago
Views: 285 • Comments: 0 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 0
Comments: 0
: 0
Russian Defense Minister Says His Military Has Tested 162 Weapons in Syria Russian Defense Minister Sergei Shoigu made his way to the Duma, the lower house of parliament, on the eve of Defender of the Fatherland Day. The Feb. 23 national holiday was once known as Soviet Army and Navy Day, ...
Tarkloon
1 day, 13 hours ago
Views: 465 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Jordan Peele’s ‘Get Out’ Scares Way to No. 1 at Box Office During his Sundance post-screening Q&A, Peele added that Get Out “was a missing piece in the genre. One of my favorite movies is the Stepford Wives and the way it dealt with social issues in regards to gender. I ...
Tarkloon
1 day, 21 hours ago
Views: 807 • Comments: 0 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0