PHP + Interbase speed issue

[Anon]

Hello everyone,
When I connect and do a simple select (select col1, col2 from test_table) on an Interbase database, there is about a 1-2 sec time to set up the connection. Using ibase_pconnect, this time is reduced to .5 sec for subsequent connections (only for a short while though); A comparable connection to mysql seems instant (as though the file is static). This is still unacceptable, though. I'm sure there must be some way to overcome this problem.

I've tried the following combinations:
win32 cgi + win32 interbase
win32 apache mod + win32 interbase
win32 apache mod + linux interbase
linux apache mod + linux interbase

I have the same problem with every combination.

I really need to use interbase because of it's features, and I like ibconsole too.

--tony

[smarlowe]

Well, maybe you should look at postgresql, which is a close match in features to interbase, with a nearly compleat (OE) implementation of SQL92, and a nice console.

It's also pretty damned fast (7.0.3 can do about 10 to 30 bank style double ledger transactions a second) and the beta freaking hauls ass (7.1beta4 can do up to about a hundred or so banking transactions a second)

I can connect to the same box about 50 times a second on postgresql without persistant connects, and tens of thousands of times a second with persistant connects. Either your interbase setup is way suboptimal or interbase has expensive connections and an expensive connection protocol.