TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,453

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
Slap
A Song About A Mighty Big Marine
On this Memorial Day, I got to thinking about how many songs about soldiers in general tend to be over-laden with cliche' and patriotism. (This is purely an aesthetic judgment on my part, nothing more.) For me, the best songs ...

1 hour, 49 minutes ago
Views: 63 • Comments: 0
Tweets: 0 • Rating: 0
Nyet
A Short Documentary About Chechnya’s Ramzan Kadyrov: “The Family”.
Mikhail Khodorkovsky's Open Russia foundation has presented this mini-documentary about the role of Ramzan Kadyrov in modern Chechnya - and in Putin's Russia. I may have aesthetic and other minor differences with the makers of the film, but I agree ...

2 hours, 46 minutes ago
Views: 71 • Comments: 0
Tweets: 0 • Rating: 0
Thanos
Paul Mccartney & Dave Grohl ‘I Saw Her Standing There’ @ 02 London 2015
PAUL MCCARTNEY & DAVE GROHL 'I SAW HER STANDING THERE' @ 02 LONDON 2015

3 hours, 11 minutes ago
Views: 64 • Comments: 0
Tweets: 0 • Rating: 0
FemNaziBitch
The US Military’s Sexual-Assault Problem Is So Bad the UN Is Getting Involved
The US military has a problem with sexual violence. That's the conclusion of the Universal Periodic Review Panel, a UN panel that aims to address the human rights records of the 193 UN member states. This is the second ...

16 hours, 24 minutes ago
Views: 165 • Comments: 0
Tweets: 0 • Rating: 0
#FergusonFireside
IDignity - Restoring Dignity and Hope by Providing Identification
IDignity is the organization my Brother works for & my Mother volunteers for. It is a model organization, and hoping to expand. Without an ID, you do not exist. idignity.orgfacebook.com IDignity was created to help the disadvantaged in Central Florida ...

2 days, 17 hours ago
Views: 293 • Comments: 1
Tweets: 3 • Rating: 3
Cheechako
Meyer: Make the School Year a Full Year
OPINION Meyer: Make the school year a full year By Jeremy Meyer The Denver Post POSTED: 05/22/2015 12:28:06 PM MDT8 COMMENTS| UPDATED: ABOUT 3 HOURS AGO Colorado's attendance law requires districts to provide at least 1,056 hours of instructional ...

2 days, 18 hours ago
Views: 259 • Comments: 1
Tweets: 0 • Rating: 2
Great White Snark
Elizabeth Warren Rouses California Democrats: ‘America Is Ready to Stand With Us’
I emboldened (bolded ?) that last line as it most agrees with why I have a hard time settling for a candidate I don't like because they appear less harmful than the other. For some this is really a primary ...

3 days, 2 hours ago
Views: 316 • Comments: 2
Tweets: 0 • Rating: 0
jhncsy
How America’s First Female Detective Helped Foil An Assassination Plot
If reading The Bourne Identity and watching Burn Notice has taught me anything, it's that spies need to blend in. Kate Warne was a master at this: The novelty of a female detective in those days meant Warne was able ...

3 days, 21 hours ago
Views: 564 • Comments: 0
Tweets: 19 • Rating: 4
CriticalDragon1177
The Independent - New health minister opposed to abortion urged to reconsider stance
The United States isn't the only western nation where some people want to restrict access to abortion. It sounds like certain British politicians would want to limit when, where, and how a women can get one, assuming they wouldn't like ...

1 week, 2 days ago
Views: 739 • Comments: 0
Tweets: 6 • Rating: 2
Uraniabce
Omar Khadr walks free on bail after 13 years in custody
After 13 years of incarceration, after torture and abuse, after being abandoned by his own government, Omar Khadr is finally freed. "Mr. Khadr you're free to go," Alberta judge says in denying Ottawa its emergency motion. Ottawa condemns the release ...

2 weeks, 3 days ago
Views: 1,117 • Comments: 0
Tweets: 32 • Rating: 4
 Frank says:

"Wowie Zowie" is what [Pamela Zarubica] says when she's not grouchy...who would guess it could inspire a song? No one would guess. None of you are perceptive enough. *Why are you reading this?* -- Liner notes for "You Didn't Try to Call Me" (yes, really) on "Freak Out!"