> My app has typically been used in an office environment but now people
> are starting to use it over a VPN. I know Firebord's protocol is
> 'chatty' and not suioted to slow connection so I plan to port my app
> to a 3-tier architecture using kbmMW.
>
> In the meantime, is there anything I can with regards to IBO
> components that could improve performance over slow connections (e.g.
> FetchAll). I will attempt to cache more data and restrict the amount
> of preparing/unpreparing etc.

Preparing is good.

Prepare a statement before use, and use parameters for additional
statement executions, this way, there's a whole lot less work to be
done.

Don't unprepare the statements unless there's a specific reason for it.

Request small resultsets only. You could try and use Zebedee in between.


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com