November 1st, 2010, 12:20 AM
Firebird 2.0 extremely slow
I have Firebird 2.0 Classic running on a Debian 64bit and run queries via the ibase functions in PHP.
Loading pages that call Firebird queries sometimes take up to 10-20 seconds compared to only a fraction of a second for static pages.
The main query that runs is just a paginated list with a join;
Watching the 'top' command shows the firebird process spiking each time the page loads, but it only ever uses 1% of CPU.
SELECT FIRST 15 SKIP 0 * FROM equipment e, client c WHERE c.clientid = e.clientid
MySQL databases on the same server run very fast.
I know this is all a bit vague, but has anybody else experienced performance issues like this?