EA on FireBird is so slow!

[Geert Bellekens]

I've been playing around with the FireBird backend to make the EA Navigator add-in work on that repository as well. (don't you just love the subtle differences in SQL "standard")
By testing it I noticed that it is lots and lots slower then .eap.
From my gut feeling (I haven't actually measured it) from fast to slow measured on a scale from 1 to 10
- .eap (MS Access) => 1
- MySQL => 3
- Oracle => 5
- .feap (FireBird) => 10

What is your experience?

Geert

[qwerty]

Maybe its more an Icy Snail than a FireBird

q.

[motivatedgorilla]

Do you mean to say that an EAP is faster than MySQL or Oracle? Are you referring to an EAP stored on a local drive or an EAP stored on a network drive? What about the number of users connecting to it?

[Eve]

My (crude) understanding is that firebird indexes don't work the way you want unless you update the index statistics.

EA has a command for that under Tools | Data Management | Manage FireBird file.

Try giving that a go and see if it helps.

[Geert Bellekens]

Simon,

I'll try that to see if it works better that way. I'll post the results tomorrow.

Just to put my results into context, I installed Oracle and MySQL locally on my desktop machine and I compared that manually with .eap and .feap both local on my hard drive and with myself as only user.
The differences are most obvious when using the EA Navigator quicksearch feature.

Geert