Could it be Windows making a backup of the FDB-file every time you start accessing it? That has been a well known problem...
Regards Poul Fra: [email protected] [mailto:[email protected]] På vegne af kelpiedave Sendt: 9. februar 2012 01:03 Til: [email protected] Emne: [firebird-support] Delays on reading database - Windows 2008 R2 - Firebird 2.0.5 Hi All We have just rolled in a new server to run our firebird application. It is a good spec IBM x3550, RAID 1 with 12 GB RAM. When reading from the database, it seems there is a significant pause, 3 -4 seconds. This happens when running the app over the network or locally on the server. On a more lowly speced windows 7 machine the application runs fine. Responses are almost instantaneous. Just wondering if anyone has any suggestions on where to take this. All of our IBM firmware and drivers are the latest possilbe. The disk and CPU benchmark good performance, disk queues, memory usage and CPU barely move when doing these requests. Thanks David [Non-text portions of this message have been removed]
