I have used other databases such as Oracle, Informix, SQLServer, MySQL, Access, etc. I am considering a contract for writing input templates and cleaning up several FileMaker databases. I understand there are 250K records in one of their databases, and I was surprised that they had that large a database without considering another database alternative.
What is the typical FileMaker application? Can FileMaker handle databases of this size without performance issues?