Database vs Cards

[Alan Gayne]

Geoff:

This sounds like what I'm looking for.  However, I have NO experience 
with storing data in arrays - other than the very simple "lines & items" 
approach frequently utilized in Hypercard - and this mostly for short 
term storage in local variables.

I would certainly appreciate if you could possibly give a small example 
of how data might be saved to such an array and then how a particular 
record might then be displayed.  Also, how would searching and sorting 
be handled in such an arrangement?

Like I said, I would really appreciate help on this topic as I'm really 
trying to break free of my old Hypercard way of doing things.

Thanks in advance,

Alan
On Monday, October 14, 2002, at 01:46  PM, Geoff Canyon wrote:

> At 8:29 PM +1000 10/14/02, David Vaughan wrote:
>> I mentioned recently that I have another app to transfer. It contains 
>> about a thousand cards in one background plus other backgrounds for 
>> help information, storing certain lists and summaries and so on. 
>> Planning it, I was groping towards an interface-and-data model 
>> (without wishing to go right to an SQL database, although I have done 
>> that before with an HC front end), so I am finding your comments on 
>> this pretty interesting. Anyone else like to comment on the worth of 
>> such a transition? Or whether I should even go straight to Valentina 
>> for 1,000-2,000 records? They are normally accessed individually for 
>> single update rather than reported or modified en masse.
>
> For 1,000 to 2,000 records, plain text or arrays will be fine. Cards 
> would be too, but I've tried creating stacks with ten thousand cards, 
> and performance suffers. With arrays or text, you can easily go to 
> 10,000 records or so, depending on what your base platform is for 
> deployment. You can stretch arrays and plain text to a few tens of 
> thousands of records with little extra effort, but eventually memory 
> becomes an issue. When that happens is your call.
> --
>
> regards,
>
> Geoff Canyon
> gcanyon at inspiredlogic.com
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>