FM Server vs other servers
I am used to using Microsoft SQL server 2005 and 2008. Can anyone give me some feeling as to how the FM server compares to these? For example, can it hold 10 milllion records with say 5 indexes, if the hardware is powerful enough? How much RAM can it really use? Do you have to reindex more often, etc.?
Assume a server with 8g Ram, two new CPU's, and a Raid array of 15k rmp disks.