Firebird comunication protocol is known to be slow in high latency
networks (internet). FB 2.1 had improvements in this area, and is
supposed to be +/- 30% faster compared to previous versions, but you
need to upgrade the client libraries too to take full advantage.

Even so, the protocol is still slow. Right now I'm talking with some
core developers to see if they can improve this more, for FB 3 and
maybe FB 2.5.2 too.

PS: If you change your app to use n-tier model, the communication
protocol between the client machine and the application server will
not be the FB one, so probably you could get better speed.

[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

CC> Background:

CC> I am developing a GIS application for Win32 in Delphi XE using
CC> TatukGIS VCL DK 10 and Firebird 1.5. I save large aerial
CC> photography files as SQL Layers (BLOBs) using Tatuk's PixelStore
CC> format. Many of my users are remote, and hit against my server to
CC> load layers. At this point I provide access to the SQL Layers
CC> through ODBC. The speed for people accessing them from beyond my
CC> firewall is not great and I need to improve it if possible.

CC> Questions:

CC> 1) Is ODBC the way to go here, or should I use another driver, like DBX?

CC> 2) Would I see an improvement in speed by using a more modern version of Firebird?


CC> Thanks



CC> ------------------------------------

CC> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

CC> Visit http://www.firebirdsql.org and click the Resources item
CC> on the main (top) menu. Try Knowledgebase and FAQ links !

CC> Also search the knowledgebases at http://www.ibphoenix.com

CC> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CC> Yahoo! Groups Links