Home » RDBMS Server » Networking and Gateways » network load with large queries.
network load with large queries. [message #367560] Fri, 26 June 1998 11:40 Go to next message
Messages: 1
Registered: June 1998
Junior Member
Hi there,

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.

Re: network load with large queries. [message #367562 is a reply to message #367560] Mon, 13 July 1998 08:36 Go to previous message
Kev Thomas
Messages: 4
Registered: July 1998
Junior Member
Hi Nicolas,

There may be a way to do this, but first can you tell me, where is the query being executed from?
SQL*Plus, PL/SQL, Forms, Reports etc.

This may have a bearing on the answer to your original problem.

Previous Topic: SQL*Net client-side
Next Topic: Running SQL*Net V2 and Net8 together
Goto Forum:

Current Time: Sun Mar 03 16:07:19 CST 2024