<?xml version="1.0" encoding="UTF-8"?>











<rss version="2.0" xmlns:jf="http://www.jivesoftware.com/xmlns/jiveforums/rss">



<channel>
    <title>Support Forums: Message List - Iterative Data Access Pattern (Complete)</title>
    <link>http://www.theserverside.com</link>
    <description>Most recent forum messages</description>
    <language>en</language>
    
        <generator>Jive Forums Silver 5.5.30 (www.jivesoftware.com)</generator>
    
    <pubDate>Sat, 25 May 2013 10:55:45 -0400</pubDate>


    <item>

        <title>Page-by-page iterator variation</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[Sorry, this is the complete message:<br><br><br>I had such problem in a project and finally we implement<br>a compromise that allow to get a subset on the server (e.g 300 to 1000 rows among the 1 000000). The client can play with this subset using page...]]></description>
        

        <pubDate>Wed, 30 Jun 2004 08:51:56 -0400</pubDate>

        

        <jf:creationDate>Wed, 30 Jun 2004 08:51:56 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 30 Jun 2004 08:51:56 -0400</jf:modificationDate>
        <jf:date>Jun 30, 2004</jf:date>
        <jf:author>Vincent MATHON</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>Page-by-page iterator variation, uses EJBQL and CMR</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[I had such problem in a project and finally we implement<br>a compromise that allow to get a subset on the server (e.g 300 to 1000 rows among the 1 000000). The client can play with this subset using page up, page down until he needs some rows that are...]]></description>
        

        <pubDate>Wed, 30 Jun 2004 06:39:26 -0400</pubDate>

        

        <jf:creationDate>Wed, 30 Jun 2004 06:39:26 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 30 Jun 2004 06:39:26 -0400</jf:modificationDate>
        <jf:date>Jun 30, 2004</jf:date>
        <jf:author>Vincent MATHON</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>


    <item>

        <title>My few cents</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[Guys,...]]></description>
        

        <pubDate>Fri, 24 Oct 2003 14:58:12 -0400</pubDate>

        

        <jf:creationDate>Fri, 24 Oct 2003 14:58:12 -0400</jf:creationDate>
        <jf:modificationDate>Fri, 24 Oct 2003 14:58:12 -0400</jf:modificationDate>
        <jf:date>Oct 24, 2003</jf:date>
        <jf:author>Mikhail Shnayderman</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>Page-by-page iterator variation, uses EJBQL and CMR</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[Anybody care to comment on this Page-by-page iterator variation which uses EJBQL and CMR instead of JDBC.  I haven't used it or verified it in any way....]]></description>
        

        <pubDate>Fri, 10 Oct 2003 02:22:14 -0400</pubDate>

        

        <jf:creationDate>Fri, 10 Oct 2003 02:22:14 -0400</jf:creationDate>
        <jf:modificationDate>Fri, 10 Oct 2003 02:22:14 -0400</jf:modificationDate>
        <jf:date>Oct 10, 2003</jf:date>
        <jf:author>Denis Diggin</jf:author>
        <jf:replyCount>3</jf:replyCount>
    </item>


    <item>

        <title>It's possible to page it in the database</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[It is possible to implement paging in the database. Eg you do not need to return huge queries back to the EJB layer. ...]]></description>
        

        <pubDate>Thu, 09 Oct 2003 07:32:56 -0400</pubDate>

        

        <jf:creationDate>Thu, 09 Oct 2003 07:32:56 -0400</jf:creationDate>
        <jf:modificationDate>Thu, 09 Oct 2003 07:32:56 -0400</jf:modificationDate>
        <jf:date>Oct 9, 2003</jf:date>
        <jf:author>Ivar Bundulis</jf:author>
        <jf:replyCount>4</jf:replyCount>
    </item>


    <item>

        <title>Problems</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[The ROWNUM of oracle is not a recommended approach, as the solution will tie the implementation to a specific database. Plus, if the use want's to see a SORTED result on the front-end, it will become a cumbersome process to sort it....]]></description>
        

        <pubDate>Sun, 05 Oct 2003 12:49:19 -0400</pubDate>

        

        <jf:creationDate>Sun, 05 Oct 2003 12:49:19 -0400</jf:creationDate>
        <jf:modificationDate>Sun, 05 Oct 2003 12:49:19 -0400</jf:modificationDate>
        <jf:date>Oct 5, 2003</jf:date>
        <jf:author>balaji thirugnanam</jf:author>
        <jf:replyCount>5</jf:replyCount>
    </item>


    <item>

        <title>why not pre-sort the results, store this and then query it</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[The following is the paging pattern I am currently implementing....]]></description>
        

        <pubDate>Wed, 01 Oct 2003 18:01:05 -0400</pubDate>

        

        <jf:creationDate>Wed, 01 Oct 2003 18:01:05 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 01 Oct 2003 18:01:05 -0400</jf:modificationDate>
        <jf:date>Oct 1, 2003</jf:date>
        <jf:author>bruce goldstein</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>Nothing comes without cost</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[There is no miracle cure to the problem of large result sets. We cannot &quot;make a wish&quot; and create a reality in which a result set with &gt;300,000 rows somehow is compressed to only take up 7 1/2 bytes of memory. I don't think even Java 1.5 can...]]></description>
        

        <pubDate>Mon, 29 Sep 2003 14:01:54 -0400</pubDate>

        

        <jf:creationDate>Mon, 29 Sep 2003 14:01:54 -0400</jf:creationDate>
        <jf:modificationDate>Mon, 29 Sep 2003 14:01:54 -0400</jf:modificationDate>
        <jf:date>Sep 29, 2003</jf:date>
        <jf:author>Rich Rosen</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>


    <item>

        <title>Page by page iterator with cmp</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[You could use ejbSelect() to get only the primary keys and keep them in a SFSB. When the client asks for, say, the next 50 rows, get the value objects, put them in a Collection and return it. ...]]></description>
        

        <pubDate>Tue, 23 Sep 2003 11:15:33 -0400</pubDate>

        

        <jf:creationDate>Tue, 23 Sep 2003 11:15:33 -0400</jf:creationDate>
        <jf:modificationDate>Tue, 23 Sep 2003 11:15:33 -0400</jf:modificationDate>
        <jf:date>Sep 23, 2003</jf:date>
        <jf:author>Markus H?rnvi</jf:author>
        <jf:replyCount>2</jf:replyCount>
    </item>


    <item>

        <title>page by page iterator with cmp</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[all you've talked solutions using jdbc2 but what about when you are using cmp the only thing i've been thinking so far is to hold an amount of objects in a collection and retrieve this data with some programing techniques but as you all have said when we...]]></description>
        

        <pubDate>Mon, 22 Sep 2003 18:11:33 -0400</pubDate>

        

        <jf:creationDate>Mon, 22 Sep 2003 18:11:33 -0400</jf:creationDate>
        <jf:modificationDate>Mon, 22 Sep 2003 18:11:33 -0400</jf:modificationDate>
        <jf:date>Sep 22, 2003</jf:date>
        <jf:author>Luis Ramirez</jf:author>
        <jf:replyCount>3</jf:replyCount>
    </item>


    <item>

        <title>No need to concede</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[First of all, where is message #45624? I'm not sure how one gets to a particular message number without knowing the thread here on TheServerSide.com....]]></description>
        

        <pubDate>Thu, 18 Sep 2003 13:20:35 -0400</pubDate>

        

        <jf:creationDate>Thu, 18 Sep 2003 13:20:35 -0400</jf:creationDate>
        <jf:modificationDate>Thu, 18 Sep 2003 13:20:35 -0400</jf:modificationDate>
        <jf:date>Sep 18, 2003</jf:date>
        <jf:author>Rich Rosen</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>I Conceed</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[I see that it has already been mentioned.
<br>
<br>Message #45624.]]></description>
        

        <pubDate>Wed, 17 Sep 2003 17:11:15 -0400</pubDate>

        

        <jf:creationDate>Wed, 17 Sep 2003 17:11:15 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 17 Sep 2003 17:11:15 -0400</jf:modificationDate>
        <jf:date>Sep 17, 2003</jf:date>
        <jf:author>Michael Barker</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>


    <item>

        <title>I Conceed</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[Although I am not 100% convinced that the pattern is entirely bad, as it works well in our domain (small number of clients, few large queries), but the majority rules and I agree its not good in the general case....]]></description>
        

        <pubDate>Wed, 17 Sep 2003 17:03:06 -0400</pubDate>

        

        <jf:creationDate>Wed, 17 Sep 2003 17:03:06 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 17 Sep 2003 17:03:06 -0400</jf:modificationDate>
        <jf:date>Sep 17, 2003</jf:date>
        <jf:author>Michael Barker</jf:author>
        <jf:replyCount>6</jf:replyCount>
    </item>


    <item>

        <title>Two things...</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[I'm not sure I understand what's being suggested as an alternative here. If CachedRowSets (or other disconnected containers as well?) are unsuitable for very large result sets, what IS suitable? Leaving the Connection open and holding on to the...]]></description>
        

        <pubDate>Wed, 17 Sep 2003 10:18:19 -0400</pubDate>

        

        <jf:creationDate>Wed, 17 Sep 2003 10:18:19 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 17 Sep 2003 10:18:19 -0400</jf:modificationDate>
        <jf:date>Sep 17, 2003</jf:date>
        <jf:author>Rich Rosen</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>Two things...</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=21434</link>

        

        
            <description><![CDATA[I have the impression that if we have to manipulate 300 000 + rows, there are mainly two cases :...]]></description>
        

        <pubDate>Wed, 17 Sep 2003 02:35:00 -0400</pubDate>

        

        <jf:creationDate>Wed, 17 Sep 2003 02:35:00 -0400</jf:creationDate>
        <jf:modificationDate>Wed, 17 Sep 2003 02:35:00 -0400</jf:modificationDate>
        <jf:date>Sep 17, 2003</jf:date>
        <jf:author>Sebastien Couturiaux</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>



</channel>
</rss>

