TwitterFacebook

Tech Note: The LGF Pages Reboot

Integrated
LGF • Views: 29,076

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.

Last updated: 2014-03-07 2:19 pm PST

LGF User's Guide
Recent Pages
cycroft
Russ Campbell’s Blog: Bill C-23, Fair Elections Act Seems Now on Solid Ground
Now that a Sen­ate com­mit­tee has rec­om­mended nine changes to Bill C-23, Fair Elec­tions Act, the leg­is­la­tion seems pretty solid. And, since Pierre Poilievre has, ap­par­ently, in­di­cated pri­vately that he's open to changes, an amended ver­sion of the bill will likely be­come law by this sum­mer. We would prob­a­bly have got­ten to this point ear­lier had not the min­is­ter re­spon­si­ble for the bill ...

2 hours, 6 minutes ago
Views: 37 • Comments: 0
Tweets: 0 • Rating: 0
FemNaziBitch
Calif. TV Station Films Dog Calmly Playing With Kids After Cop Shoots Himself Trying to Kill It
Video at link. A California deputy accidentally shot himself while trying to kill a dog that he said was threatening his life on Wednesday, but video captured by a local television station later showed the animal much smaller than reported and peacefully playing with children. According to a Riverside County sheriff's spokesperson, the deputy was serving an eviction notice at around 2 p.m. on ...

5 hours, 33 minutes ago
Views: 141 • Comments: 1
Tweets: 0 • Rating: 1
Randall Gross
Putin Decrements Our Peace Dividend: U.S. Ground Troops Being Deployed To Poland
If you were looking to the wind down of the Afghan war as creating a potential peace dividend, that's now unlikely due to Putin's nationalistic moves on the Ukraine. Poland and the United States will announce next week the deployment of U.S. ground forces to Poland as part of an expansion of NATO presence in Central and Eastern Europe in response to events in ...

8 hours, 14 minutes ago
Views: 252 • Comments: 0
Tweets: 17 • Rating: 0
palmerskiss
Denmark Shows the World How to Stop Mass Medicating Animals
COPENHAGAN, Denmark -- Michael Nielsen unlocks the door to his pig factory. He doffs his jacket, pants and muddy boots and zips on white coveralls. Then he steps into the maze-like complex housing several thousand pigs. From the birthing room -- where one enormous sow has just delivered 22 squirming piglets -- to the insemination stalls where the next generation is in the ...

19 hours, 25 minutes ago
Views: 104 • Comments: 0
Tweets: 0 • Rating: 0
MichaelJ
Live now - 2014 Rip Curl Pro Bells Beach - ASP World Tour
More: 2014 Rip Curl Pro Bells Beach - ASP Iconic Bells Beach in Victoria, Australia once again hosts the world's best surfers for the 41st running of the Bells Beach Contest. New feature in this broadcast: drone cam!

22 hours, 10 minutes ago
Views: 144 • Comments: 0
Tweets: 3 • Rating: 0
Skip Intro
Why the Temperature of the Yellow Sea Is a Big Deal, and Other Questions About the South Korean Ferry Disaster
The boat ran into trouble several dozen miles from Jindo, an island that sticks out of South Korea's southwestern corner like a little toe. Jindo is surrounded by a group of even smaller islands that are slightly farther afield from the mainland. The ferry was curving around those small islands at the time it issued a distress call. What caused the disaster? We ...

1 day, 3 hours ago
Views: 304 • Comments: 3
Tweets: 25 • Rating: 1
Idle Drifter
Calgary stabbings: How knife crime in Canada can cause ‘moral panic’
What Calgary police chief Rick Hanson called the "worst mass murder" in the city's history didn't end at the barrel of a gun. Instead, the 22-year-old suspect identified on Tuesday as Matthew de Grood is accused of entering the kitchen at a house party, taking "a large knife" and using it to fatally stab four men and one woman, all of whom were students ...

2 days, 13 hours ago
Views: 216 • Comments: 4
Tweets: 0 • Rating: 0
aagcobb
New York Electoral College: State Joins National Popular Vote Interstate Compact.
Ben Mathis-Lilley, Slate: New York Electoral College: State Joins National Popular Vote Interstate Compact. Instead of pushing for a Constitutional amendment, which would have to be ratified in 38 states, advocates ask individual state legislatures to pass an agreement: that they'll pledge all their presidential electors to the winner of the national popular vote as soon as enough other states pass the law to ...

2 days, 20 hours ago
Views: 226 • Comments: 7
Tweets: 0 • Rating: 2
Political Atheist
The Insane History of Rockets at Jet Propulsion Laboratories
The Rocket Boys In the late 1930s, a group of Caltech graduate students were booted off campus after blowing up (part of!) their building during a rocket test gone awry. Unwilling to give up on the joy of semi-controlled explosions, the students and a few of their friends headed into the San Gabriel Mountains. They picked a deserted gully -- Arroyo Seco -- ...

3 days, 17 hours ago
Views: 263 • Comments: 0
Tweets: 0 • Rating: 2
iossarian
Drug Companies Want Your Money
Two thematically-related stories on the BBC at the moment: UK drug company Glaxo 'paid bribes to Polish doctors' UK drug company GlaxoSmithKline is facing a criminal investigation in Poland for allegedly bribing doctors, BBC Panorama has discovered. Tamiflu: Millions wasted on flu drug, claims major report Hundreds of millions of pounds may have been wasted on a drug for flu that works no better ...

3 days, 23 hours ago
Views: 264 • Comments: 0
Tweets: 8 • Rating: 0
 Frank says:

Nobody looks good bent over. Especially to pick up a cheque. -- Guitar Magazine 1984