Too much data problem
Too much data problem
Hi,
I have a website in dot.net 2.0 + DB Oracle.
I am dealing with loading a huge amount of data (select of 100, 000 and more).
The problem is that it's taking too much time.
Is there any built-in way (in Oracle) to define amount of rows to load at a time ? or some special procedure?
Thanks,
Moria
I have a website in dot.net 2.0 + DB Oracle.
I am dealing with loading a huge amount of data (select of 100, 000 and more).
The problem is that it's taking too much time.
Is there any built-in way (in Oracle) to define amount of rows to load at a time ? or some special procedure?
Thanks,
Moria
The common way to solve such a problem is to implement manual paging.
Here is the query for retreiving the rows from DEPT table having row number between p1 and p2:
Let me know if this answers your question.
Here is the query for retreiving the rows from DEPT table having row number between p1 and p2:
Code: Select all
SELECT deptno, dname, loc FROM (SELECT deptno, dname, loc, ROW_NUMBER() OVER (ORDER BY deptno) R FROM dept) WHERE R BETWEEN :p1 and :p2;
Yes, it does. The OracleDataSource component is available in design time in an ASP.NET web application, and it has built-in paging support. Please try using dotConnect for Oracle 5.00 Professional Trial (free use during 30 days).
You can download it here: http://www.devart.com/dotconnect/oracle/download.html
You can download it here: http://www.devart.com/dotconnect/oracle/download.html