TechFold - Bold tech & web commentary
Bold tech & web commentary
Subscribe to RSS FeedTechFold is technology discussion, commentary, reviews, and opinions from well outside the valley. There's no koolaid to drink here, and TechFold is not in SL, or on Twitter.
The value of database indexing
Sheesh. I just sped up the TechWatching.com script that writes the main page by an order of magnitude just by looking at my queries and re-jiggering related table indexes. I am a total amateur and have the greatest of respect for those who’ve made databasing and computer science their career.
Now onto sorting out character encoding and why Magpierss doesn’t seem to like CDATA blocks — arghh. BTW - the move I wrote about to SimplePie? Hasn’t quite worked out. For whatever reason, SimplePie disregards a lot of blog posts in feeds that Magpie happily picks up. So I’m back to Magpie and its related problems.
database, indexes, magpierss simplepieIf you enjoyed this post, make sure you subscribe to my RSS feed!
Related Posts
Spock: Idiocy Writ Large
TechWatching Blog Search is coming along…
CastTV - is there room between verticals and gootube?
Testing Wordpress Geotagging Plugin
http:BL - Anti-Spam Tech for Servers from the HoneyPot Project
2 Responses to “The value of database indexing”
Leave a Reply
Subscribe to TechFold RSSRecent Posts
- Google Blogsearch: the Techmeme sapper
- Stubhub Revisted
- Yahoo and Bain: What’s Really Going On
- IE7 Hanldes Flash Way Better than Firefox3
- Microsoft is Hamstringing themselves
- Does anyone else think Google is over-extending itself?
- Going Travelling? Try VentureFar.net
- If you could go anywhere in the world and meet with any geek, executive, or company, who would it be?
- Is Apple Paying for Product Placement in Paperbacks?
- Scoble and Twitter in the Borneo Bulletin: the future of news?
Recent Comments
Post Archives
- October 2008 (1)
- September 2008 (6)
- July 2008 (2)
- May 2008 (5)
- April 2008 (9)
- February 2008 (5)
- January 2008 (26)
- December 2007 (28)
- November 2007 (16)
- October 2007 (7)
- September 2007 (17)
- August 2007 (15)
- July 2007 (19)
- June 2007 (67)
- May 2007 (62)
- April 2007 (66)
- March 2007 (1)
Categories
Links
This is Ryan from the SimplePie project. I’d be interested in learning more about the issues you’ve had so that we can either fix bugs or whatever else we need to do to make this easier/simpler for you. Thanks!
Ryan - thanks for coming by! Its weird - when I point SimplePie at the same set of RSS feeds as Magpie, SimplePie sees many fewer posts for whatever reason. Its possible there’s a bug in my implementation, however - this is still something I’m diagnosing. Anyway - as soon as I find anything actually useful, I’ll be sure and let you know.
best regards,
–Rod.