Database vs Cards

Geoff Canyon gcanyon at inspiredlogic.com
Mon Oct 14 14:53:01 EDT 2002


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




More information about the use-livecode mailing list