> From: Charles Yeomans <charles at declareSub dot com>
> Date: Tue, 21 Mar 2006 11:24:13 -0500
>
> 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.
Let me add that we are adding right now into Valentina
new XML features which can give you best of 2 worlds.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
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>
|