TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,239

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
Randall Gross
Outside Group Sends Blunt Message in N.C. Senate Race : It’s All Politics : NPR
Kochs support 3rd party candidate to scuttle Democrat chances in North Carolina. "More weed, less war." That's the latest campaign slogan in the North Carolina Senate race advertising wars. And no, neither Democratic incumbent Kay Hagan nor Republican challenger Thom ...

41 minutes ago
Views: 40 • Comments: 0
Tweets: 0 • Rating: 0
FemNaziBitch
Bullied Teen Lands in Hospital After Being Beaten, School Presses Charges - Against Bullied Teen - the New Civil Rights Movement
Almost six weeks after his brutal beating, while still recovering from a traumatic brain injury, Eric Martin walked into a Virginia courtroom last week to face two assault charges. Verbally abused, harassed and bullied since the first grade in ...

1 hour, 24 minutes ago
Views: 103 • Comments: 0
Tweets: 0 • Rating: 2
EiMitch
Cracked: 6 Halloween Pranks for Sociopaths With Unlimited Budgets
cracked.com America's No. 1 holiday celebrating violence and candy is just around the corner, and this year it looks to be better than ever, as the glorious union of art and technology has given us several exciting new ways to ...

1 day, 10 hours ago
Views: 262 • Comments: 0
Tweets: 0 • Rating: 1
Skip Intro
‘Pro-Life’ Group: No Ebola Vaccine if Stem Cells Are Used
A "pro-life" group called Children of God for Life is throwing a fit because Ebola vaccines currently being developed use cells derived from embryonic stem cells. Because it's totally "pro-life" to let living people die of Ebola when it ...

1 day, 19 hours ago
Views: 414 • Comments: 6
Tweets: 0 • Rating: 5
Lumberhead
Moulton Underplays Military Service - Metro - the Boston Globe
This really is remarkable. I came across it over at Charlie Pierce's blog at Esquire. Imagine, a politician downplaying his heroic war record. The American political graveyard has more than a few monuments to politicians and public officials who embellished ...

2 days, 21 hours ago
Views: 296 • Comments: 1
Tweets: 0 • Rating: 0
Souliren
Natalie MacMaster Fiddle school
This is a short (under two minute) video of Natalie teaching a technique for "Athole Brose," in Cape Breton style.

3 days, 15 hours ago
Views: 289 • Comments: 0
Tweets: 0 • Rating: 2
MichaelJ
Amazing RED Camera Footage Kelly Slater’s 540 Air
More: Amazing RED Camera Footage Kelly Slater's 540 Air There's a reason why people refer to 11-time world champ Kelly Slater as "the king". This clip/maneuver is yet another ground-breaking moment in the history of surfing.

5 days, 12 hours ago
Views: 541 • Comments: 3
Tweets: 6 • Rating: 5
Rightwingconspirator
1934 Had Worst Drought of Last Thousand Years-We Made It Worse
"It was the worst by a large margin, falling pretty far outside the normal range of variability that we see in the record," said climate scientist Ben Cook at NASA's Goddard Institute for Space Studies in New York. Cook ...

5 days, 20 hours ago
Views: 613 • Comments: 0
Tweets: 0 • Rating: 5
blah blah ad hominem mumbo jumbo.
Daniel Johnston-True Love Will Find You In The End.
A simple, imperfect, brilliant song, by a fascinating man. Link

1 week, 3 days ago
Views: 626 • Comments: 0
Tweets: 0 • Rating: 2
Bubblehead II
High Court Lifts Hold on Gay Marriage in Idaho
[large]YES![/large] WASHINGTON - The Supreme Court says same-sex marriage can go ahead in Idaho. More: High Court Lifts Hold on Gay Marriage in Idaho [large]YES![/large]

1 week, 5 days ago
Views: 831 • Comments: 1
Tweets: 12 • Rating: 2
 Frank says:

Well, you and I would differ on what's ignorance and educated. -- Senator Ernest Hollings to Zappa