November 1st, 2010, 12:20 AM
|
|
Registered User
|
|
Join Date: Oct 2010
Posts: 1
Time spent in forums: 49 m 44 sec
Reputation Power: 0
|
|
|
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;
Code:
SELECT FIRST 15 SKIP 0 * FROM equipment e, client c WHERE c.clientid = e.clientid
Watching the 'top' command shows the firebird process spiking each time the page loads, but it only ever uses 1% of CPU.
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?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
