Kevin Miller wrote:
>
> On 18/6/00 11:40 pm, Bruce Lewis <[EMAIL PROTECTED]> wrote:
>
--snip--
>
> > Would there there be danger to my data in large stacks? Would there be an
> > undue speed hit?
>
> Becase (as already mentioned) the entire stack gets loaded into memory, you
> could expect the stack to take longer to load. But access should be fast
> enough. You might find that you could break your database up into multiple
> stacks, for example one for each letter of the alphabet, and set them to be
> deleted from memory on close.
Perhaps not exactly in the thread but...
To get a good speed in parsing a MC database of 25 000 records for 6.2
Mo of datas, i store the datas in a texte file loaded
by the preopenstack script at once, as two vars (datas - 4.2 Mo and
index - 2 Mo) and than divide the datas var in 25 subvars. To search the
records to parse to the web or to a metacard front-end window, i use,
first, "repeat for each line in var index + get offset" - seems faster
than the filter command for multi-string searches on big vars - in the
index var and, second, parse the datas stored in the right lines of the
25 datas subvars.
All the answers are coming back in less than 25 ticks even if displaying
them on the web can be a little longer than on an 100 Mb intranet
network or in a local Metacard frontend window...
(Test refs.: Suse Linux 6.3, PII 300, 160Mo Ram, MC 2.3 using 21 Mo of
Ram maxi)
You can watch to the MacOS/WebStar/Hypercard equivalent of this database
running for yet on the web at
<http://crdp.intereduc.net/cgi-bin/ssi/cndp.ssi> i builded as a simple
test version before building the Linux/Apache/Metacard issue (soon on
the web).
(Test refs.: MacOS 8.1, G3 266, 288Mo Ram, HC 2.41 with 32 Mo of
allocated Ram)
To the end, the Linux/Metacard issue is just 500% faster than the
MacOS/Hypercard is ;-).
My 2 cents...
>
> Regards,
>
> Kevin
>
> Kevin Miller <[EMAIL PROTECTED]> <http://www.xworlds.com/>
> Cross Worlds Computing, MetaCard Distributors, Custom Development.
> Tel: +44 (0)131 672 2909. Fax: +44 (0)1639 830 707.
Regards, Pierre Sahores
CRDP de l'academie de Creteil
WEB, DB, ASP, VPN, B2B design
Archives: http://www.mail-archive.com/metacard%40lists.best.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm
Please send bug reports to <[EMAIL PROTECTED]>, not this list.
