TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,427

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.

^ back to top ^

TwitterFacebook

Turn off all ads for a full year by subscribing!
Take advantage of our yearly subscription, and save 50% off the normal subscription price! One-year ad-free subscriptions are just $59.95. Turn off all ads for a full year by subscribing now and save!
Read more...

► LGF Headlines

  • Loading...

► Tweeted Articles

  • Loading...

► Tweeted Pages

  • Loading...

► Top 10 Comments

  • Loading...

► Bottom Comments

  • Loading...

► Recent Comments

  • Loading...

► Tools/Info

► Tag Cloud

► Contact

You must have Javascript enabled to use the contact form.
Your email:

Subject:

Message:


Messages may be published unless you request otherwise.
Tech Note:
Using the Contact Form
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-04-18 5:26 pm PDT

LGF User's Guide
Recent Pages
FemNaziBitch
APNewsBreak: Pentagon Accused of Withholding Sex Crimes Info
WASHINGTON (AP) -- The number of sex-related crimes occurring in U.S. military communities is far greater than the Defense Department has publicly reported, a U.S. senator said Monday in a scathing critique that asserts the Pentagon has refused to ...

1 hour, 35 minutes ago
Views: 55 • Comments: 0
Tweets: 0 • Rating: 0
Thanos
What Was the Venus de Milo Doing With Her Arms?
The Venus de Milo is a paradox: the embodiment of beauty, yet disfigured. And she is a puzzle, gazing serenely at something we cannot see, something once held, we assume, by her missing arms. "La Vénus de Milo est ...

1 hour, 59 minutes ago
Views: 61 • Comments: 0
Tweets: 0 • Rating: 0
Cheechako
Biologists Report First Wild Bison Birth in Alaska in at Least a Century
Suzanna CaldwellAlaska News DispatchMay 1, 2015 Biologists monitoring the new Innoko River wood bison herd got a pleasant surprise last month during an aerial survey of the animals: a bison calf, the first born in the wild in at least ...

2 days, 13 hours ago
Views: 254 • Comments: 1
Tweets: 0 • Rating: 3
Romantic Heretic
The United States of Amnesia
My news aggregator found this interesting article about how the US has no history. Which brings this cartoon to mind.

3 days, 2 hours ago
Views: 315 • Comments: 2
Tweets: 0 • Rating: 3
Lumberhead
David Simon on Baltimore’s Anguish
It's long but definitely worth the time. Simon sends some flak in Martin O'Malley's direction and that will probably get some attention due to presidential politics. I thought the following passage was important to highlight but the whole thing is ...

4 days, 20 hours ago
Views: 375 • Comments: 0
Tweets: 15 • Rating: 4
No Country For Old Haters
Partridge Family’s Youngest Daughter Dies — Suzanne Crough Dead at 52
The youngest "Partridge Family" star Suzanne Crough died Monday at her home in Nevada ... TMZ has learned. Crough starred as the tambourine-shaking daughter Tracy Partridge ... during the classic sitcom's run from 1970 to 1974. She was 52 ...

5 days, 17 hours ago
Views: 487 • Comments: 1
Tweets: 1 • Rating: 0
palmerskiss
Jonah Goldberg’s Dog Is A Manchurian Liberal Plant
@JonahNRO your dog is obviously a liberal facist homo-feminazi — palmerkiss (@palmerkiss) April 27, 2015 I admit, I'd buy his dog a drink and share war stories. Secretly hoping it's a Schnauzer.

1 week ago
Views: 675 • Comments: 1
Tweets: 50 • Rating: 1
EiMitch
Cracked: 5 Things You Won’t (Want to) Believe I Saw Guarding US Nukes
cracked.com If there happens to be anyone reading LGF who opposes nuclear disarmament for any reason, you probably need to know that our doomsday arsenal is less secure than a revolving door in a prison. I'm just saying that we're ...

1 week ago
Views: 592 • Comments: 1
Tweets: 0 • Rating: 0
Higgs Boson's Mate
Sleeping Bear Dunes shipwrecks spotted by helicopter patrol
LEELANAU COUNTY, MI -- A Northern Michigan Coast Guard helicopter crew on routine patrol captured some excellent images of the shipwrecks that dot the waters off Sleeping Bear Dunes National Lakeshore. The Traverse City-based crew posted six photos on ...

1 week, 5 days ago
Views: 688 • Comments: 1
Tweets: 2 • Rating: 6
CriticalDragon1177
Skepchick - Ad Hominem Fallacy: A Lesson for Sea World ( Video )
Rebecca Watson takes on Sea World, and their attacks on John Hargrove. She takes them to task for attacking him, rather than even trying to refute his allegations, and in the process gives us a lesson in critical thinking. Read ...

1 week, 6 days ago
Views: 990 • Comments: 0
Tweets: 40 • Rating: 3
 Frank says:

The essence of Christianity is told us in the Garden of Eden history. The fruit that was forbidden was on the tree of knowledge. The subtext is, All the suffering you have is because you wanted to find out what was going on. You could be in the Garden of Eden if you had just kept your mouth shut and hadn't asked any questions. -- Playboy Interview, April 1993