Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 30,597

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
Frank Zappa - Clownz on Velvet - the Ritz (1981) FMFrank Zappa - The Ritz, NYC, 17th November 1981 - FM - With Al DiMeola on guitar. Frank Zappa: "Zappa In New York 1981" (FZ17111981-1/2)thinkfloyd61.blogspot.com.br
Thanos
7 hours, 23 minutes ago
Views: 79 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
The Big Moon - Happy New Year (Official Video) Get the debut album ‘Love In The 4th Dimension’ on signed CD & Vinyl now: thebigmoon.lnk.toDiscover more on Spotify: po.st Directed by India LeeProduced by Louise Latimer / India Lee Choreographed by Cicely Cotton Cinematographer: Joe Douglas Art Director: ...
Thanos
8 hours, 7 minutes ago
Views: 91 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
MGMT - When You Die Get "When You Die" now: smarturl.it Directors: Mike Burakoff & Hallie Cooper-NovackVFX Supervisor: Jamie DutcherStarring: Alex Karpovsky & Lucy KaminskyProducers: Lucia Pier & Jamie DutcherExecutive Producers: Adam Kurland & Matt Wyatt DP: Steven BreckonEditor: Max GoldblattLogo Design: Benjy BrookeProduction ...
Thanos
21 hours, 4 minutes ago
Views: 157 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Noah Kahan - Hurt Somebody Hurt Somebody (Official Video)Song Available Here: lnk.to See all Noah Kahan tour dates at: noahkahan.com Follow Noah Kahan:Facebook: facebook.com Instagram: instagram.com Twitter: @noahkahan Spotify: republic.lnk.to SoundCloud: SoundCloud Directed by Chris GriederProduced by Antonio FloresFor Aqsent Music video by Noah ...
Thanos
21 hours, 8 minutes ago
Views: 172 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
HOFFMAN FILES Instant “Axis” - All Hitler, All the Time.blog.timesunion.com When I was 14 or so, my parents were nice enough to take me on a trip to California.  The last stop in our journey was San Francisco.  My parents had been there once before and were quite fond ...
rhoffman
1 day, 18 hours ago
Views: 232 • Comments: 0 • Rating: 0
Tweets: 3 • Share to Facebook
Shares: 1
Comments: 0
: 1
Russia’s Putin Visits Syria Airbase and Orders Start of Pullout Russian President Vladimir Putin has ordered the partial withdrawal of Russian troops from Syria, during an unannounced visit there on Monday. Mr Putin was met by Syrian President Bashar Assad as he arrived at the Russian Hmeimim air base, ...
Thanos
4 days, 21 hours ago
Views: 238 • Comments: 0 • Rating: 0
Tweets: 3 • Share to Facebook
Shares: 0
Comments: 0
: 0
Orkestra Obsolete Play Blue Monday Using 1930s Instruments - BBC Arts More information: bbc.in New Order's Blue Monday was released on 7 March 1983, and its cutting-edge electronic groove changed pop music forever. But what would it have sounded like if it had been made 50 years earlier? In a ...
Thanos
5 days, 18 hours ago
Views: 267 • Comments: 0 • Rating: 2
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Tune-Yards - ABC 123 (Official Video) 'ABC 123' by Tune-Yards. New album 'I can feel you creep into my private life' is released January 19th 2018: smarturl.it Director: Dear Mr QuistgaardProducer: Abi Atkinson, LS ProductionsCommissioner: Gabe Spierer, Beggars GroupExec Producer: Saskia Whinney, SomesuchDOP: Deepa KeshvalaEditor: ...
Thanos
5 days, 18 hours ago
Views: 217 • Comments: 0 • Rating: 0
Tweets: 0 • Share to Facebook
Shares: 0
Comments: 0
: 0
Funding Restrictions Have Made Gun Violence Researchers Get Creative A study published Thursday concludes that a subsequent increase in gun exposure led to more accidental firearm deaths than otherwise would have occurred in the months after the school shooting. "It was the spike [in sales] itself that sort ...
Thanos
5 days, 21 hours ago
Views: 278 • Comments: 0 • Rating: 0
Tweets: 1 • Share to Facebook
Shares: 0
Comments: 0
: 0
Recycling Chaos in U.S. As China Bans ‘Foreign Waste’ Like many Portland residents, Satish and Arlene Palshikar are serious recyclers. Their house is coated with recycled bluish-white paint. They recycle their rainwater, compost their food waste and carefully separate the paper and plastic they toss out. But recently, ...
Thanos
5 days, 21 hours ago
Views: 544 • Comments: 0 • Rating: 1
Tweets: 3 • Share to Facebook
Shares: 0
Comments: 0
: 0