Hello, we use a CAD system (CARD / 1), which saves a few settings in a Firebird database. There is a central database and many project-specific databases. The software runs on Windows 7 Professional . Firebird is running on a server with openSUSE 13.1. The manufacturer has released only version 2.50 of Firebird . The server has a RAID 5 from three disks, 16GB RAM and an Intel Xeon E5- 2407 CPU [email protected] , 4 cores . The *.fdb data resides on a partition that is partitioned with ext4 under LVM. They are 1-10 MB in size - so rather small. We observe significant delays in project operations that use these databases. For example, taking a view of a project list sometimes 10 s or more . We are only three users of this software , so that the load of the server is very small. What can be done to achieve a fast response ?
Georg ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
