Hey everyone, been working on a free AI flight planning utility and was wondering what the largest AI Traffic bgl file people run into. The largest one that I have is the stock FS9 traffic030528.bgl which weighs in at around 15mb. Anyone seen anything significantly larger? Please advise and thanks!Mark

I have 1 combined commercial traffic file of 97mb and 1 GA traffic file of 76mb

Deleted.Damn wrong sim again

The largest I have is the original file you listed, followed closely by Traffic_PAI.bgl at almost 13 mb. PAI puts all their traffic files into one bgl, instead of breaking it up like WOAI.John

Hey everyone, been working on a free AI flight planning utility and was wondering what the largest AI Traffic bgl file people run into. The largest one that I have is the stock FS9 traffic030528.bgl which weighs in at around 15mb. Anyone seen anything significantly larger? Please advise and thanks!Mark

I have all mine split by airline or aircraft type except for one general GA flights file - this is about 23Mb in size and is comfortably the largest! The total 1543 traffic bgl files I have weighs in at just under 310Mb...Geoff

An update and a note of interest...A friend of mine provided me with a large traffic file to use for testing. Its about 100mb and generated approximately 20,000 base records and nearly 600,000 individual legs! That's a huge amount of data for any desktop app. We're talking SQL Server if they get any larger.The stock FS9 traffic file generates 28,000 base records and a bit more then double that in individuals legs. Interesting stuff...a little bit obscure but I still think worth noting :)Mark

I regularly make traffic files over 100mb in GATraffic without a problem, don't see the big deal.

I guess that it all depends on how you disseminate the data, you know, what type of functionality your app requires. To store millions and millions of rows of data and make it useful and fast can require some horse power. That is, if you want to import data into a normalized structure and not have 600,000 rows take an hour to process. Also, one mistake that can be made is testing a normalized structure with an empty database. Many desktop level dbs move a bit slower when they already have a gig of data in them :)Mark

Just an addendum to my previous comment...My normalized structure imported and disseminated 214,580 rows of data in 00:02:47. That's 2 minutes and 47 seconds. I'm trying to tweak it in so it's faster but I can live with it at that speed. Also, the database doesn't just hold the traffic file that I'm currently working with, it holds all of my traffic files. In fact, it can hold all of the traffic files in FS9...every one of them at the same time. That way you can do fun things like copy flight plans from one traffic file to another with the click of a button :)Mark