http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
No. The question is why you need to retrieve all 2 million rows. It doesn't matter whether you retrieve them 1 at a time or 1,000 at a time. The whole idea is infeasible and user-hostile.Originally posted by Pinik Tilli:
You all have same question why do i need to retrieve only 30 rows at one time. This was just an example. This number will be given by user, so this can be even in 100s. And i know very well that no one would sit and click "Next" many times.
So, i request you people to provide some solution rather than writing unnecessary stuff.
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
4. Rerun the query each time a user clicks next as you are doing, but this isn't performing well.
SELECT * FROM ( SELECT * FROM EMP, DEPT, LOC ORDER BY EMP.ENAME ) WHERE ROWNUM BETWEEN :1 and :2
Why do you think this won't perform
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
Originally posted by Maria Smith:
Can some one help with my DB2 issue
Thanks
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Originally posted by seshu Palamanti:
Thanks for your suggestion Scott Selikoff but if we create a new query altogether the we would have to again start from the 1st Row of the Result and now not from 21000+1 th row of the result set.
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
Yellapa Adepu<br />SCEA
The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.
Don't get me started about those stupid light bulbs. |