| Subject | Slow connection to database / maybe need a middleware |
|---|---|
| Author | Balanyi Zsolt |
| Post date | 2006-05-05T18:56:06Z |
Hello!
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
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