Very Slow Connection with Firebird

eelias · Post by **eelias** » 11.07.2013, 00:48

Hi there!

I am using Zeos 7.0.3 + Delphi XE2 32 bits + Firebird 1.0 (!!!)

Zeos app running in Windows XP SP3

Firebird 1.0 running on Windows 7 64bits

Connection takes at least 30 seconds. After that everything is just fine. That is a big problem for me because it is a threaded application and each thread use its own connection to provide data to a webservice. The long time of wait sometimes makes the client to disconnect.

Same scenario with Firebird 2.1 work just fine.

It seems to be something related to Firebird 1.0. I know it an old DB, however it is a legacy system used by hundreds and still need to be kept.

Is this related to Zeos or Firebird, what can I do?

Thank you

Eduardo

marsupilami · Post by **marsupilami** » 11.07.2013, 10:24

Hello eelias,

hmmm - I have to admit I have no good Idea what might be the problem. What happens if you use some external tool like isql to connect to the same database? Did you try to see what happens on the network using WireShark? Although I did not try that yet.
Is it possible to migreate the databases to Firebird 2.1? Or maybe you get better resulty by simply using the 2.1 client to connect to the old database?
Best regards,

Jan

eelias · Post by **eelias** » 11.07.2013, 19:14

Thanks for the answer,

THe best thing would be upgrading, however it is not under my control, I am writing a software for a company that use this ancient version.

So I need to stick with fb 1.0 for while.

How can I use a newer version of the client to access the fb 1? you mean using the DLLs?

Can you give me little more detailed information so i can give a try?

Many thanks !

Eduardo

Post by **EgonHugeist** » 13.07.2013, 00:04

eelias,

you mean using the DLLs?

i think he means exactly that.. Can't help you here FB1 is really to old.

eelias · Post by **eelias** » 13.07.2013, 01:09

Thansk replying Michael

But I was wondering what means:

"Or maybe you get better resulty by simply using the 2.1 client to connect to the old database? "

I wanted to give a try on that. What are the steps for that.

Thanks

Eduardo

marsupilami · Post by **marsupilami** » 13.07.2013, 11:22

Hello eelias,

you could do this by simply installing Firebird 2.1 on the client machine, for example. Or you could use the embedded Firebird server, which is also a client library. Simply download the zip file, extract the contents to your aplication directory and rename fbembed.dll to fbclient.dll for a first test.
Best regards,

Jan