Subject Slow connection to database / maybe need a middleware
Author Balanyi Zsolt

We use ZeosLib to connect to FB 1.5 server over the Internet, and have
the following problem:
When we open a query, it really takes long time. After the query is
opened, 10.000 records (consisting of five integers) are transported in
1-2 seconds. As we have many tables, operations like refresh or
scrolling with master/client datasets take long time because the queries
are closed and opened again all over. Is there a way to speed up this
procedure, or maybe I should use another database access component? I
was also thinking in using middleware on the server, but I do not know
if that would help...

Many greetings, Zsolt Balanyi