Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,080

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
WONDER WOMAN Comic-Con Trailer Her Fight Is Ours. WATCH the official Comic-Con trailer for #WonderWoman, starring Gal Gadot!--Gal Gadot stars in WONDER WOMAN - in theaters June 2, 2017.Follow #WonderWoman on social media:Facebook: facebook.comTwitter: twitter.comInstagram: instagram.com--WONDER WOMANFrom Warner Bros. Pictures and DC Entertainment ...
Thanos
1 hour, 30 minutes ago
Views: 55 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Dem Suggests Race Factored Into Obama Senate Endorsement Democrats should not be making assumptions about identity politics, this year or any other year. But Sanchez on Friday said race may have had something to do with the endorsement. "I think they have, what he said they have, ...
Thanos
2 hours, 49 minutes ago
Views: 73 • Comments: 3 • Rating: 2
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Hillary Clinton: We Don’t Need Candidates Who ‘Talk Trash About America’ AMPA, Fla. — Hillary Clinton made no mention of her potential running mate during a rally here Friday evening, instead delivering a fiery rebuttal to Donald Trump's acceptance speech at the Republican National Convention. "The last thing we need ...
Thanos
4 hours, 23 minutes ago
Views: 72 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Hillary Rodham Clinton’s Family Tree: Bill, Chelsea and More Relatives We all know Hillary, Bill and Chelsea Clinton. But what about the extended Rodham and Clinton families? Both Clintons have family members who haven’t been talked about much recently, and the family is expanding, with a second grandchild born ...
Thanos
4 hours, 28 minutes ago
Views: 83 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Blast at Kabul Demonstration Kills 81, Injures 286 KABUL, Afghanistan — At least 81 people were killed and 286 wounded Saturday in a twin bombing claimed by the Islamic State group that targeted a demonstration by members of the Hazara minority, officials and witnesses said. The marchers ...
Thanos
4 hours, 33 minutes ago
Views: 135 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
No Compassion: Far-Right Catholic Group Gloats Over Defeat of Bill to Help Victims of Clerical Abuse A few days ago, I receive the July-August issue of Catalyst, the newsletter of the Catholic League for Religious and Civil Rights. If you’re not familiar with the Catholic League, it’s a right-wing outfit that exists mainly to scream ...
Thanos
6 hours, 22 minutes ago
Views: 289 • Comments: 0 • Rating: 1
Tweets: 47 • Share to Facebook
Shares: 1
Likes: 3
Comments: 0
: 4
Energy Company That Heats and Cools Downtown Kansas City Is Going Green A rooftop restaurant on a downtown office building. A quick-melting ice rink in Sprint Center. A vanishing coal pile at the Missouri riverfront. They have nothing in common — unless you know about the network of heating and cooling ...
Thanos
10 hours, 11 minutes ago
Views: 104 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0
Soon, the Curiosity Rover Will Rule Mars With Its Automatic Lasers Don’t ever say you can’t teach an old rover new tricks. The Mars rover Curiosity, operated out of the Jet Propulsion Laboratory, received a software upgrade — similar to the ones you get on your cell phone — that ...
Thanos
21 hours, 19 minutes ago
Views: 218 • Comments: 1 • Rating: 1
Tweets: 5 • Share to Facebook
Shares: 1
Likes: 0
Comments: 0
: 1
David Duke Loved Trump’s RNC Speech: ‘Couldn’t Have Said It Better’ - Towleroad Former KKK Grand Wizard David Duke had high praise for Donald Trump’s speech accepting the Republican nomination: “Great Trump Speech, America First! Stop Wars! Defeat the Corrupt elites! Protect our Borders!, Fair Trade! Couldn’t have said it better!” Duke ...
Thanos
1 day, 7 hours ago
Views: 197 • Comments: 0 • Rating: 1
Tweets: 2 • Share to Facebook
Shares: 1
Likes: 1
Comments: 0
: 2
Marvel’s Iron Fist - SDCC - First Look - Netflix [HD]Danny Rand fights relentlessly to regain everything he's lost in Marvel's Iron Fist, coming soon to Netflix. Follow Iron Fist:Facebook: facebook.comTwitter: twitter.com
Thanos
1 day, 8 hours ago
Views: 178 • Comments: 0 • Rating: 0
Tweets: 2 • Share to Facebook
Shares: 0
Likes: 0
Comments: 0
: 0