October 17, 200025 yr Has anyone noticed a decline in performance speed in relation to the number of databases running concurrently? Also, is there a suggested limit to the number of fields on one db (as far as performance is concerned)?
October 17, 200025 yr The issues of number of open databases and number of fields in a database don't tend to be the ones that limit performance. There are hard limits (e.g. FM server 5 allows 125 open files and 250 users). Performance vs. number of fields seems to depend most of what type of fields and how they are displayed. Lots of summary fields on a layout with a large found set significantly degrades peformance. Files with 350 fields can still exhibit very good performance. The biggest performance hits on the number of files is the time it takes to open all of them! -bd
Create an account or sign in to comment