TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,676

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/pages/charles

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

Help support Little Green Footballs!

Subscribe now for ad-free access!

Contact Us LGF Pages

This button leads to the main index of LGF Pages, our user-submitted articles. You can post your own LGF Pages simply by registering a free account with us.

Create a Page

This 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: 2015-07-31 8:11 pm PDT

LGF User's Guide RSS Feeds
Recent Pages
Thanos
The Koch Brothers’ Twisted Beauty Pageant: The Disturbing Way They’re Choosing Which GOP Candidate to Buy
People who regularly read my byline will recall that back in April I wrote about poor Scott Walker making a huge gaffe just as it seemed like the Koch brothers, his presumed benefactors, were ready to go all-in on ...

39 seconds ago
Views: 3 • Comments: 0
Tweets: 0 • Rating: 0
I Stand With Planned Parenthood
The Staggering Death Toll of Mexico’s Drug War
Over the course of the wars in Afghanistan and Iraq, the number of civilian deaths has been staggering. In Afghanistan, more than 26,000 civilians are estimated to have died since the war began in 2001. In Iraq, conservative tallies ...

4 hours, 22 minutes ago
Views: 106 • Comments: 0
Tweets: 2 • Rating: 0
William Lewis
1000 Musicians “Learn To Fly”
So this gentleman in Cesena, Italy, really really wants the Foo Fighters to play there. So what does he do? He organizes an event of 1000 guitarists, bass players, drummers & singers all performing the Foo Fighter's hit, "Learn to ...

1 day, 17 hours ago
Views: 341 • Comments: 2
Tweets: 0 • Rating: 2
Eclectic Cyborg
MS GOP rep campaigns on pro Confederate Flag platform
So this showed up at my house today, it's an election mailer from one Jeffrey Guice who is running for re-election to the Mississippi State Senate. As you can see, it included an interesting detail... So basically he's taking pride ...

1 day, 18 hours ago
Views: 541 • Comments: 1
Tweets: 54 • Rating: 2
EiMitch
Cracked: 5 Sworn Enemies Who Formed Inspiring Friendships
I was catching-up with Cracked articles. I found an obvious click-bait article, "4 Sexual Preferences That Only Recently Became Taboo": cracked.com Knowing that, I read it anyway. From there, I read a depressing article, "5 Ways College Screws Over Poor ...

2 days ago
Views: 391 • Comments: 1
Tweets: 0 • Rating: 2
Skip Intro
Windows 10 is out. Help a guy out, please.
So I downloaded the Win 10 ISO image today, and started the install. The first thing I come across is a screen asking what I want to keep, my apps, data, and program settings, my data and program settings, or ...

3 days, 3 hours ago
Views: 656 • Comments: 6
Tweets: 0 • Rating: 0
Great White Snark
Huffington Post Arabic-Smart Outreach, Sure To Infuriate Bigots
Dirct Link: Huffington Post Arabic - Kudos! Good to see this. The link takes you right there, but for us non arabic readers, a helpful translate panel comes right up. You who do read arabic can judge the content, ...

5 days, 2 hours ago
Views: 711 • Comments: 0
Tweets: 19 • Rating: 1
Iwouldprefernotto
More Edited PP Videos
NYT -- More Edited PP Videos in the Pipeline The activist behind the videos, David Daleiden, has said he has enough covertly recorded footage for perhaps a dozen videos that he could release, one a week, for the next few ...

5 days, 5 hours ago
Views: 407 • Comments: 0
Tweets: 0 • Rating: 2
Predaka
Swedish Right Plans Gay Pride March Through Muslim Areas Of Stockholm
haaretz.com From the article: Swedish nationalists are planning a gay 'pride' march through Muslim-majority districts in the country's capital, according to media reports and a dedicated Facebook page. The march, called 'Pride Järva,' is scheduled to take place on July ...

5 days, 18 hours ago
Views: 727 • Comments: 12
Tweets: 0 • Rating: 1
Lumberhead
#BlackLivesMatter Shows There Are Problems in American Life That Can’t Be Blamed on the Rich
Democratic presidential candidates should take heed. They need to come up with a way to speak to this issue. Otherwise, in an Obama-less election, part of the Obama coalition may not be motivated to show up. Obviously, you can be ...

1 week, 3 days ago
Views: 521 • Comments: 2
Tweets: 1 • Rating: 2

► LGF Headlines

  • Loading...

► Tweeted Articles

  • Loading...

► Tweeted Pages

  • Loading...

► Top 10 Comments

  • Loading...

► Bottom Comments

  • Loading...

► Recent Comments

  • Loading...

► Tools/Info

► Tag Cloud

 Frank says:

I'm not black, but there's a whole lot of times I wish I could say I'm not white.