Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,217

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
What Healthcare Professionals Need to Know Before Moving Into TelemedicineTelemedicine, or the remote diagnosis and treatment of patients by utilizing online communications technologies, is a growing field that is designed to bring professional medical treatment to people who live in remote areas or are otherwise unable to obtain healthcare. ...
Holly Whitman
56 minutes ago
Views: 41 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Pistachio-Lemon Bars Recipe - NYT Cooking Ingredients The crust: 1 cup all-purpose flour ¼ cup confectioners' sugar ¼ teaspoon kosher salt ½ cup cold, unsalted butter, cut into small pieces ¼ cup shelled unsalted pistachios, roughly chopped The filling: 2 eggs 1 cup sugar ½ ...
The Vicious Babushka
7 hours, 17 minutes ago
Views: 116 • Comments: 0 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
OneRepublic - Let’s Hurt Tonight (Collateral Beauty Version)Music video by OneRepublic performing Let's Hurt Tonight. (C) 2016 Mosley Music/Interscope Records vevo.ly
Thanos
15 hours, 10 minutes ago
Views: 77 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Robert Fripp String Quintet Taken from the RFSQ Video release "Live in Japan", Trey Gunn treats us to a performance of Chromatic Fantasy in D Minor 00:00:00 and the California Guitar Trio perform Blockhead with a solo from Robert Fripp 00:01:52 On the ...
Thanos
15 hours, 19 minutes ago
Views: 92 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
SHAED - Name on It (Live) Get SHAED’s debut EP “Just Wanna See” featuring "Name On It" here: flyt.it Follow SHAED online:shaedband.comtwitter.comfacebook.cominstagram.com "Name On It" (Audio Video) Lyrics:Standing over thereRipping out my hairWant it from across the roomTake me down to your tombGet your name ...
Thanos
15 hours, 21 minutes ago
Views: 75 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Life in Obamacare’s Dead Zone “She was always the steady one,” her sister, Karen Smith Walker, says. “The one who could solve any problem. Always with a book. Always studying.” But now, after years of living with this desperation, Foy didn’t know how to ...
Thanos
22 hours, 20 minutes ago
Views: 154 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Rhythm of Breathing Affects Memory and Fear - Neuroscience News Summary: A new study reports the rhythm of your breathing can influence neural activity that enhances memory recall and emotional judgement. Source: Northwestern University. Breathing is not just for oxygen; it’s now linked to brain function and behavior. Northwestern ...
Birth Control Works
1 day ago
Views: 176 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Chocolate Peppermint Bars Recipe - NYT Cooking Ingredients For the chocolate shortbread: 1 cup/125 grams all-purpose flour ½ cup/100 grams granulated sugar 2 tablespoons/15 grams unsweetened cocoa powder ¼ teaspoon kosher salt 8 tablespoons/113 grams unsalted butter (1 stick) For the peppermint filling and chocolate top: ...
The Vicious Babushka
1 day, 1 hour ago
Views: 186 • Comments: 0 • Rating: 1
Tweets: 3 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Originalist -Justice Antonin Scalia - Jan 2011 Last October marked the 24th anniversary of Justice Antonin Scalia's appointment to the U.S. Supreme Court. Well known for his sharp wit as well as his originalist approach to the Constitution, Justice Scalia consistently asks more questions during oral ...
Birth Control Works
1 day, 1 hour ago
Views: 285 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 1
Comments: 0
: 1
‘There Are People Who Are Really Angry With Women Who Dare to Determine Their Reproduction Choices — Let Alone Run for Presiden With fewer legal requirements and methods, she said, it was less complicated back then, because PP mainly only offered diaphragms and pills. However, women had to “qualify” for tubal ligations—if enough money existed for one. One-month counseling sessions were ...
Birth Control Works
1 day, 1 hour ago
Views: 432 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0