TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,215

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!
For about 33 cents a day (per month) or 22 cents a day (per year), our subscription option turns off all advertisements at LGF!
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: 2014-03-07 2:19 pm PST

LGF User's Guide
Recent Pages
team_fukit
Eight Member Ebola Health Team Killed by Angry Mob in Guinea
Will 3000 troops be enough to send to West Africa? France is also building a military hospital in Guinea. Ebola outbreak: Guinea health team killedBBC Eight members of a team trying to raise awareness about Ebola have been killed by ...

22 minutes ago
Views: 20 • Comments: 0
Tweets: 0 • Rating: 0
Lumberhead
The Great ‘Out-0f-Network’ Scam Is Eating Patients Alive. And It’s Supposed To.
And there you have it. It's a great racket that allows doctors to extort loads of money from those in the most pain and with the least ability to fight back. None of them want the gravy train to ...

1 hour, 52 minutes ago
Views: 79 • Comments: 0
Tweets: 0 • Rating: 0
iceweasel
Psychology Today: Internet Trolls Are Narcissists, Psychopaths, and Sadists
In this month's issue of Personality and Individual Differences, a study was published that confirms what we all suspected: internet trolls are horrible people. Let's start by getting our definitions straight. An internet troll is someone who comes into ...

2 hours, 1 minute ago
Views: 71 • Comments: 2
Tweets: 0 • Rating: 0
BadExampleMan
Now HERE’S How You Quit Your Job
You'll want to watch this again and again. The aghast expression on the anchor's face is the perfect capper.

2 hours, 1 minute ago
Views: 79 • Comments: 0
Tweets: 0 • Rating: 0
Randall Gross
Why This Tiny Italian Restaurant Gives a Discount for Bad Yelp Reviews
In recent years, Yelp has been publicly accused of extortion--asking for money from businesses that are automatically listed on the site in exchange for preferred placement on the site. There are also accusations of abruptly vanishing positive reviews and ...

2 hours, 23 minutes ago
Views: 70 • Comments: 0
Tweets: 0 • Rating: 0
Souliren
Cape Breton fiddler Andrea Beaton
Celtic Colours Festival 2010 Everyone seems to be having fun here.

1 day, 19 hours ago
Views: 230 • Comments: 3
Tweets: 0 • Rating: 3
Bubblehead II
LOHAN Coming to the States
Cool. Due to Spain being a jerk, the Registers bringing their LOHAN project to the States. More specifically, New Mexico's Spaceport America Don't let the cheesy writing style and Brit humor of the Registers reporters put you off. There is ...

1 day, 21 hours ago
Views: 256 • Comments: 1
Tweets: 0 • Rating: 2
FemNaziBitch
‘I Was Really Stressed Out’: Anxiety Rules the Secret Life of Teens - Parents - TODAY.com
When hormones, grades and peer pressure rule your life, turmoil often follows. Yet many families don't realize how crippling the stress can be for their teenagers. TODAY's series on the secret lives of teens began Wednesday with NBC special ...

2 days, 22 hours ago
Views: 324 • Comments: 0
Tweets: 0 • Rating: 0
theliel
AEI Decides to Weigh in on #GamersGate
So Polygon showcases the AEI's anti-femminist response to #gamergate talking about how games are for dudes and dudes need that space to continue being dudes and bitches should get back in that kitchen where they belong. Link is to Polygon ...

4 days, 21 hours ago
Views: 406 • Comments: 0
Tweets: 0 • Rating: 1
CriticalDragon1177
Alternet - Nicholas Wade’s Flawed Book Rewrites the History of Scientific Racism
Jon Phillips takes on Nicholas Wade's claims, and proves once again that so called "scientific" racism is little more than a pseudoscience. This was originally posted in September 2014 edition of the Southern Poverty Law Center's Intelligence Report, ( ...

5 days, 16 hours ago
Views: 578 • Comments: 3
Tweets: 3 • Rating: 5
 Frank says:

The language and concepts contained herein are guaranteed not to cause eternal torment in the place where the guy with the horns and pointed stick conducts his business.