Robert Brenstein :
> >I just read that Panorama recently released v4.0 (see
> ><http://maccentral.macworld.com/news/0107/10.panorama.shtml>).
> >
> >Given that both MC and Panorama are RAM-based, anyone have insights into why
> >building databases in native MC is discouraged?
> >
>
> I am not an expert but you are looking at apples and oranges. You can
> build small databases in MC with no problems, but I think that the
> card paradigm does not work well for large databases (like millions
> of records).
Indeed. But if you consider using external txt files for storing
the database records, with sophisticated indexing, it may be
possible.
According to some experiments I did lately, using lineoffset,
itemoffset and some (rather sophisticated) indexing, I found
that elements can be retrieved quite fast (0.5 to 1.5 second)
among a list of 2000 to 10000 records.
Actually performances & limits vary according to the type
& complexity of the data... And 10000 being the upper
limit.Most likely 5000 records is an acceptable compromise.
One problem is the native MC "sort" command which is
rather slow. But I guess that using an external could make
things easier...
JB
Archives: http://www.mail-archive.com/metacard@lists.runrev.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm
Please send bug reports to <[EMAIL PROTECTED]>, not this list.
