Page 1 of 1
Too much data problem
Posted: Thu 18 Dec 2008 11:27
by moriay
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
Posted: Thu 18 Dec 2008 14:27
by AndreyR
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:
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;
Let me know if this answers your question.
Posted: Sun 21 Dec 2008 09:16
by moriay
Hi,
Thanks for the reply.
I know the manual paging, but I am looking for a built-in way.
I know it's exist in Sql Server, So I assume it's exist also in Oracle.
By the way, what is the command "over" ?
Thanks a lot!
Moria
Posted: Mon 22 Dec 2008 10:01
by AndreyR
Do you use OracleDataSource component? It has built-in paging support, just like SqlDataSource does.
Posted: Tue 23 Dec 2008 08:14
by moriay
No, I use OracleConnection.
But I didn't find OracleDataSource in the toolbox,
to use instead the ObjectDataSource ?
Thanks!
Posted: Tue 23 Dec 2008 09:50
by Shalex
Could you please tell us the edition of dotConnect for Oracle you are using? If the edition is professional (or professional trial), add the OracleDataSource component in your toolbox manually (right click in Toolbox | Choose Items).
Posted: Tue 23 Dec 2008 13:25
by moriay
where can I check the editor of dotConnect ?
I use simply OracleConnection, OracleCommand and OracleDataAdapter.
By the way, it does not exist also in the 'Choose Items' dialog box.
Thanks!
Posted: Tue 23 Dec 2008 15:09
by Shalex
Please go to the Visual Studio Tools | Oracle | About dotConnect for Oracle. If you don't have the mentioned menu item in your Visual Studio, you are using the Express edition.
Posted: Wed 24 Dec 2008 08:10
by moriay
Hi,
I am sorry, It was a misunderstanding.
I thought the forum has general help for Oracle, because I do'nt have your product 'dotConnect for Oracle'.
But does your product has a solution for my problem ?
Thank you very much,
Moria
Posted: Wed 24 Dec 2008 09:26
by Shalex
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
Posted: Thu 25 Dec 2008 09:07
by moriay
Thank you very much!
I will try it.