I am facing a problem about the method to select to process and display. writing a store procedure for Oracle database.
I am doing the enquiry screen something like page 1, until page 100. each page have display 100 row.
each time have select more than 10 or 20 thousand records.. then using looping get from line
1000 to line 1100. then pass to front end and display, it take too long time.. about 5 seconds to 9 seconds.. make it less than 1 second.
anyone can help me to improve the speed?
any idea something like... just select from XXX row to XXX row.. then pass to front end.. without any looping. or other better idea..
thank you ..hopefully probvide with the syntax