https://bugzilla.novell.com/show_bug.cgi?id=872302 https://bugzilla.novell.com/show_bug.cgi?id=872302#c0 Summary: Large delays ( > 10 seconds ) for queries on small firebird databases Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: x86-64 OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: Kernel AssignedTo: kernel-maintainers@forge.provo.novell.com ReportedBy: georg.weickelt@ibedelmann.de QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:28.0) Gecko/20100101 Firefox/28.0 We observe significant delays in project operations that use firebird 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. We use a CAD system on windows, which saves a few settings in a Firebird database. Firebird is running on a server with openSUSE 13.1. The manufacturer has released only version 2.50 of Firebird , but the problems exist also with version 2.5.2. The server has a RAID 5 from three disks, 16GB RAM and an Intel Xeon E5- 2407 CPU 0@2.20GHz , 4 cores . The *.fdb data resides on a partition that is partitioned with ext4 under LVM, but the problem exist also if I move them to a ram-disk. They are 1-10 MB in size - so rather small. Networking works over a Broadcom BCM95720. Reproducible: Always Steps to Reproduce: Sorry only with the cad-system possible 1. 2. 3. Actual Results: slow response > 10 - 40s Expected Results: fast response < 2 s -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.