Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,488

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
Why You Can’t Take a Flag to a National Cemetery Why You Can't Take a Flag to Arlington (or other national veteran cemeteries) Stars and Stripes, reprinting with permission an article from the Washington Post, explains why you cannot take a flag to Arlington National Cemetery (or any other ...
Anymouse 🌹
2 days, 5 hours ago
Views: 292 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Another Democrat Starting Trump Impeachment Process Come on guys, get behind the bill. All of us. we should get behind this bill as it emerges as fast as we attacked the BCA. Following Donald Trump’s equivocating of white supremacists and those who oppose them in ...
Unshaken Defiance
3 days, 14 hours ago
Views: 507 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 1
Comments: 0
: 1
How Militias Became the Private Police for White Supremacists Magazine Guns to a protest? Clubs? We can not tolerate anti American militias. The bloody weekend in Charlottesville that began with several hundred chanting white supremacists on a torch-lit march will long be remembered for the searing image of a ...
Unshaken Defiance
3 days, 15 hours ago
Views: 505 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Starting in 2018, Police Dogs Injured in the Line of Duty Can Be Transported by EMS to Veterinary Clinics ST. CLAIR COUNTY, IL – Ambulances are for people. It’s always been the law of the land. In Illinois, it'll soon be "almost always". Illinois Governor, Bruce Rauner, signed House Bill 2661, Tuesday. It will allow police dogs to ...
Birth Control Works
3 days, 18 hours ago
Views: 495 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The New War on Birth Control - Pacific Standard Although it wasn't clear at the time, the attack on Phillips marked the beginning of a new anti-contraception movement—conceived in the U.S., but unfolding in Africa, where women's frustrations with the dearth of safe, effective family planning options are ...
Birth Control Works
3 days, 18 hours ago
Views: 557 • Comments: 0 • Rating: 1
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
M83 - Do It, Try It (David Wilson Video) M83 - Do It, Try It video by David Wilson. Following the video's premiere at Sundance Next Fest it is now available to watch online. The track is taken from M83's seventh studio album Junk, available to buy & ...
Thanos
4 days, 9 hours ago
Views: 438 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Marvel’s the Defenders It’s all coming together. Learn about The Defenders from the stars themselves: Charlie Cox, Krysten Ritter, Mike Colter and Finn Jones. Marvel’s The Defenders premieres globally August 18, 2017, only on Netflix. Watch The Defenders on Netflix: netflix.com SUBSCRIBE: ...
Thanos
4 days, 9 hours ago
Views: 469 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
AG Madigan Issues Guidelines for Responding to Sexual Assault Crimes “We took a comprehensive look at why sexual assault survivors rarely report their crimes to law enforcement, and it was clear that our criminal justice system can and must respond, investigate and better support survivors,” Illinois Attorney General Lisa ...
Birth Control Works
4 days, 14 hours ago
Views: 446 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
This 91-Year-Old Woman Just Earned Her Bachelor’s Degree After 10 Years of Studying The back-to-school commercials have started airing. The summer reading lists are coming due. It’s almost that time of year. And if students aren’t quite looking forward to getting back into their classrooms this month for another school year, the ...
Birth Control Works
4 days, 15 hours ago
Views: 336 • Comments: 1 • Rating: 1
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Give the Gift of LifeCJ was a good kid, he was a gentle soul. I could see a little of his mother and father in him. I didn't know we were alike in one way, that we were both addicts, until he was brain ...
Shropshire Slasher
4 days, 16 hours ago
Views: 272 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0