On Mar 21, 2006, at 11:12 AM, Jason Toews wrote:
I have an app written in RB, which manages some data about cars being
advertised... I have a text file containing master
Year/Make/Model/Body Type data. I want to make this data available
within my app, so that when the user enters the Year of the car, the
Make popup gets populated with all possible Makes for the given Year.
When the user has selected a Year and a Make, the Model popup gets
populated with all possible Models for the given Year and Make. When
the user has selected a Year, Make, and Model, the Body Type popup
gets populated with all possible Body Types for the given
Year/Make/Model.
The text file containing the master Year/Make/Model/Body Type data
contains approximately 5200 records. Each record is in the format:
"year", "make", "model", "list of body types" <return>
Obviously, I want the population of the popups to happen as quickly as
possible. My question: What format should I use for storing and
manipulating the Year/Make/Model/Body Type data? What format would
most effectively facilitate queries such as:
Give me the 'Model' value from every record where 'Year' = 2004 and
'Make' = "Honda"
XML? REALDatabase? Or something else?
I think using a Valentina database would allow you to do what you want
as quickly as possible. If you want to keep your data in a text file,
then it would certainly be possible to do what you want at reasonable
speed by reading the data into appropriate data structures.
--------------
Charles Yeomans
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|