Too many records returned through the internet

From: <kacerl_at_hotmail.com>
Date: Mon, 22 Mar 1999 15:23:22 GMT
Message-ID: <7d5n8u$mh1$1@nnrp1.dejanews.com>

Hello,

Does anyone know the acceptable limit of records that can be returned to a Client through the internet? On our system, a client has the potential to run an order by query on a table which contains 1.3 million records. There is a serious performance problem in doing this and our DBA often ends up having to kill the process.

The only solution that I can think of is to require the user to provide more detail in their query to limit the result set. The owner of the application doesn't want to limit the user and compares several mainframe applications that run DB2 & ADABASE, which don't seem to have this problem.

Our internet apps. have an HTML front-end and are currently using Oracle 7.3.3.4.0 for the back-end. Any advice/direction would be greatly appreciated...

Thanks,
Larry

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 22 1999 - 09:23:22 CST