Has anyone ever had performance issues with a FileMaker database that is regularly accessed through FileMaker Pro clients and via ODBC on FileMaker Server?
We have a couple web apps that run some select and insert queries against a database hosted on FileMaker server. Lately we've noticed a real slow-down in the database's performance while open in a FileMaker Pro client. This database will only have around 30-40 users at any given time. We have a good server setup with a quad-core Intel processor, SSDs and 16GB of RAM so I don't understand why FileMaker Server is struggling so much to handle the database.