Capabilities: RTF editing, Graphs, flat-file database
sarahr at genesearch.com.au
Wed Jun 9 21:17:45 CDT 2004
>> Just to add to Ken's answer about data storage:
>> The one-card-per-record method will get rather unwieldy and slow if
>> have 60,000 records. I wouldn't recommend that method for more than
>> about 1000 records.
>> Another very popular way is to use a single data field with one line
>> per record, and each field in the record separated by some delimiter,
>> usually tab. The whole field can be loaded into memory allowing very
>> fast searching, sorting etc.
>> Also, you might want to consider XML which saves your data externally
>> in a file that can be read by many applications, but uses Rev's fast
>> XML library for searching, editing etc.
> BTW, when do you guys decide to use an SQL database instead of a single
> file loaded in memory of a flat-file database ?
> Is it related to the number of records ? the number of items per
> record ?
> The complexity of the treatments to be done on the records ?
Simple - if it has to be multi-user, go for SQL. If it doesn't then
Rev's internal mechanisms are more than adequate :-)
More information about the use-livecode