🚀 go-pugleaf

hades@dartmouth.edu (Brian Hughes) writes:

> s914370@minyos.xx.rmit.OZ.AU (David Morrison) writes:
> 
> >The database will continue to grow to the extent of having 10,000 to
> >100,000 records stored in it. Now I'm under the impression that FM Pro will
> >not be able to search this size database very quickly (within 30 - 60 secs).
> 
>     Well, since FM Pro indexes all of its fields, including Calculation
> fields, this is probably a good impression to be under. How fast Fm Pro
> will perform the search will depend on 2 things: How fast your computer
> is, and how fast you access to the HD storing the database file is,
> obvioulsy if you are trying to do this kind of search over the network
> it will take longer. But it is important to remember that FM Pro is disk
> based.
> 

At my office, our main FM Pro db has just reached 70,000 records and 15 MB
in size.  We find that when a search includes a date field, multiple
requests, or will have a large amound of 'found' records it really bogs
the system down.  If you're lucky and your search will return a few hundred
(or just a handful) or records, FM Pro shines.

FYI-Main stuff on a IIci, being used by a handful of SEs and a dialup via
ARA.


#--------------------------------------------------------------------------#
|  grub@bbs.draco.bison.mb.ca (Gordon Grieder; Winnipeg, Manitoba, Canada) |   
              |
#------------------------------------------------------------------------- #
|  "Why do you think she is a witch?"   "Well she turned me into a newt!"  |
|  "A newt?"                            "I got better..."                  |
#--------------------------------------------------------------------------#