|network load with large queries. [message #367560]
|Fri, 26 June 1998 11:40
Registered: June 1998
I was wondering if there is a way to limit number of rows retrieved from the server in a C/S architecture.
For example if a client execute a query and omits some conditions in it, the server may have to return
million of rows (if you have huge databases) which leads to a dramatic drop of network performances.
These rows are even not usable by the client !!
Did some one ever work on this problem. If there a parameter in Oracle or SQL net to define ‘too big’ queries an prevent them from being executed.
Or is there a way to sent the result back to the client in smaller chunks so that he eventually doesn’t have
to receive the entire result.
This problem deals with preserving network performances when large databases are involved.
Thank for your answers.