[firebird-support] Firebird and RAID

Hi, What factors do we need to be aware of relating to Firebird and RAID controllers? We have a customer using a Firebird 2.0.6 Classic Server database on a single disk connected to an IBM ServeRAID M5015 SAS/SATA Controller. The disk is not part of any RAID array. The server is running Window

[firebird-support] Query slowness

Hi, I am currently using Firebird 2.5.1.26351 using Classic Server 64-bit. The database file was created with Firebird 2.5.1.26351 and is 546MB with a page size of 8192. The server and client are both running on my Windows 7 64-bit development machine. I ran the following query using FlameRobi

[firebird-support] Understanding query performance changes

Hi, In upgrading from Firebird 2.0 to Firebird 2.5, I have a query that has dramatically changed performance. It would be great if I could understand the performance information given in FlameRobin, and how this can be used to return the query to its former performance. The statistics reported

[firebird-support] Re: Understanding query performance changes

Hi Set, Thank you very much for your help! Your query runs much faster than even the original query did, and is easier to understand. Regards, Gareth --- In firebird-support@yahoogroups.com, Svein Erling Tysvær wrote: > > >Hi, > > > >In upgrading from Firebird 2.0 to Firebird 2.5, I have a qu

[firebird-support] Difference between embedded and classic server behaviour

Hi, When attempting to run queries with a large number of expressions in the where clause, I have found a difference in behaviour between embedded and classic server: Note that this is a simplified case from my application's actual behaviour. I am using Firebird 2.5.2 Security Update 1 build

[firebird-support] RE: Difference between embedded and classic server behaviour