Path: utzoo!mnetor!uunet!lll-winken!lll-lcc!ames!eos!aurora!labrea!Lindy!liemandt
From: liemandt@Lindy.STANFORD.EDU (Joe Liemandt)
Newsgroups: comp.databases
Subject: Re: HUGE DATABASE ON THE MAC!
Message-ID: <471@Lindy.STANFORD.EDU>
Date: 1 Mar 88 20:13:53 GMT
References: <8283@eleazar.Dartmouth.EDU>
Reply-To: liemandt@Lindy.UUCP (Joe Liemandt)
Organization: Stanford Data Center
Lines: 20
Keywords: 4th Dimension

In article <8283@eleazar.Dartmouth.EDU> aegis@eleazar.Dartmouth.EDU (Aegis - Dartmouth Yearbook) writes:
>
>The database is comprised of ~4000 records with 30 fields per record.
>
>I am considering a Mac SE w/ 20M internal drive.  The software would
>probably be 4th Dimension. The database file is approxiamately 5 MegaBytes.
>Does anyone know any problems this configuration will have?  Suggestions?
>I am concerned about 4D being able to sort a 5MByte file with only 1 Meg
>of memory. (4D itself is a 750k)


4th Dimension will be fine.  It can easily handle 5,000 records on a Plus.
4D stores a pointer in memory for each record. So the theoretical maximum is 
about 100,000 records on a 1 meg machine.(4D uses about 550-600k of memory
itself)  I personally have a 7,500 record file in 4D and it runs fine 
on a Plus.  Because 4D only stores pointers for records, the size of your
datafile is not a concern, number of records is.

E-mail if you have any more questions.
Joe Liemandt
liemandt@jessica.Stanford.EDU