TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

  • Services
  • About
  • CF Alive
  • Blog
  • Podcast
  • Contact

Where’s That Bus?

October 30, 2006 By Michaela Light Leave a Comment

As a result of our past work on WMATA’s successful Trip Planner application (www.wmata.com/), TeraTech is currently working on another major transit project.  The client is a major transit authority, and the ultimate result will be real-time bus data for its customers, available via web browser, cell phone or PDA.  Two separate sources of internal bus routing and schedule data must be combined and converted into a proprietary XML format to be used by another application.  It’s a huge batch process that runs only occasionally, when anything changes in the routes or schedules, and it must be 100% accurate and reliable.  The client uploads nearly 300 MB of data, some in a database and the rest as flat text files, and our system performs complex data transformations including merging, validation, and interpretation.  We load the data into a relational database, and then use complex queries to generate the XML.  Although the processing is done in parts and combined at the end, the sheer size of the finished output file makes optimization of code and memory performance a critical factor.  After performing this “magic” our automated system notifies the client that their XML data is ready to download and sent to the customer-facing application.

  • Facebook
  • Twitter
  • LinkedIn

Filed Under: ColdFusion and other news

← Previous Post Insurance e-commerce
Next Post → Query of Query bug

Popular podcast episodes

  • Revealing ColdFusion 2021 – Rakshith Naresh
  • CF and Angular – Nolan Erck
  • Migrating legacy CFML – Nolan Erck
  • Adobe API manager – Brian Sappey
  • Improve your CFML code – Kai Koenig

CF Alive Best Practices Checklist

Modern ColdFusion development best practices that reduce stress, inefficiency, project lifecycle costs while simultaneously increasing project velocity and innovation.

Get your checklist

Top articles

  • CF Hosting (independent guide)
  • What is Adobe ColdFusion
  • Is Lucee CFML now better than ACF?
  • Is CF dead?
  • Learn CF (comprehensive list of resources)

Recent Posts

  • Migrating to Adobe ColdFusion 2023: Seamlessly Transitioning to the Future
  • Exploring the Exciting Features of Adobe ColdFusion 2023: A Comprehensive Overview
  • Into The Box 2023 – Modernize (ColdFusion) or Die
  • Adobe ColdFusion 2023- Codename Fortuna (Beta Released, Open for Testing)
  • ColdFusion Hosting: How To Choose the Best One

Categories

  • Adobe ColdFusion 11 and older
  • Adobe ColdFusion 2018
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion 2023
  • Adobe ColdFusion Developer week
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Summit
  • AWS
  • CF Alive
  • CF Alive Podcast
  • CF Camp
  • CF Tags
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFUnited
  • ColdBox
  • ColdFusion and other news
  • ColdFusion Community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Maintenance
  • ColdFusion Performance Tuning
  • ColdFusion Projects
  • ColdFusion Roadmap
  • ColdFusion Security
  • ColdFusion Training
  • CommandBox
  • Docker
  • Fixinator
  • Frameworks
  • Fusebox
  • FusionReactor
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn CFML
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Ortus Developer Week
  • Ortus Roadshow
  • Server Crash
  • Server Software
  • Server Tuning
  • SQL
  • Survey
  • Survey results
  • TestBox
  • Transcript
  • Uncategorized
  • Webinar
  • Women in Tech
  • Home
  • Services
    • ColdFusion Consulting
    • ColdFusion Development
    • ColdFusion Maintenance
    • ColdFusion Security
  • About Us
  • CF Alive
    • CF Alive Book
    • CF Alive Inner Circle
    • CF Alive full resources cheatsheet
  • Blog
  • Podcast
    • Podcast Guest schedule
  • Contact
  • Sitemap

The ColdFusion Experts:
Develop, Secure, Optimize

TeraTech Inc
451 Hungerford Drive Suite 119
Rockville, MD 20850

Tel : +1 (301) 424 3903
Fax: +1 (301) 762 8185

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Pinterest Follow us on YouTube

 

(Gandalf, the CF wizard,

can often be found in Hobbiton)

Copyright © 1998–2023 TeraTech Inc. All rights Reserved.