Orison Almeida wrote: > > My problem is that this works fine with > small tables but hangs with long ones (800,000 rows) > because the app server seems to fetch all rows > from the database server at once, > causing app server to hang.
That is correct. Although it is more likely the App Server will slowly eat all the RAM and then the swap and then die than justhang. > I've seen Oracle issues about SELECTing > a small number of rows using rownum/rowid > but all issues seems not to work in a > SELECT statement with ORDER clauses. There are some examples of how to do that together with an ORDER BY clause in the Oracle Knowledgebase. > Please any ideas? I pretty wild thing to explore would be to have a java class that gets a cursor from the database and then fetches sets of 10 rows to CF when CF requests it. If you put the class in the session scope it might even be persistent enough to be reused. Don't know how this would behave with session timeouts though (and it won't work across clusters). Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
