Subject | Re: Firebird and TatukGIS - DBX or ODBC |
---|---|
Author | Craig Cox |
Post date | 2011-12-31T13:57:30Z |
One thing I forgot to mention was that my server in linux. Is an n-tier model supportable in that situation?
Thanks
Thanks
--- In firebird-support@yahoogroups.com, "Carlos H. Cantu" <listas@...> wrote:
>
> 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
>