How do you page large DB result sets?

Ask a Question related to Macromedia Flex General Discussion, Design and Development.

  1. #1

    Default How do you page large DB result sets?

    Hello,

    Does anyone have examples how you would use remote objects or web services to handle large DB result sets in flex?

    Thanks
    ed
    kedward Guest

  2. Similar Questions and Discussions

    1. elp with Multiple Result Sets inside a Stored Procedure
      I have a stored procedure that returns an output variable as well as a result set. It is one that works fine with a .NET application and I am...
    2. DataAdapter and multiple result sets
      I have a SQL Server stored procedure that returns multiple recordsets (three of them), in the same way that sp_helpdb does (try entering EXEC...
    3. Multiple Result Sets from DB2 stored Procedure
      Did you figure out the solution to the problem you stated where you are not seeing all the columns of the multiple recordsets returned by a DB2...
    4. How to use returned result sets from a client app?
      Hi there, In the IBM sample file (see /opt/IBM/db2/V8.1/samples/cpp), spserver.sqC, it implemented a routine called two_result_sets(...). In...
    5. #23682 [Fbk->NoF]: sybase_query and multiple result sets: not returning first row set
      ID: 23682 Updated by: sniper@php.net Reported By: uk at dataway dot ch -Status: Feedback +Status: No...
  3. #2

    Default Re: How do you page large DB result sets?

    Check out this blog by Matt Chotin, it is the first of 3 articles. You will find the others on this site as well.

    [url]http://www.markme.com/mchotin/archives/004610.cfm[/url]


    SPSman Guest

  4. #3

    Default Re: How do you page large DB result sets?

    Another suggestion would be to handle the paging on the server. You may not
    want to load a ton of data on the clientside if your target audience is running
    anything lower than broadband. To handle the paging on the server you may just
    need a start parameter and a pageSize parameter and let JDBC do the paging. If
    you are using EJBs, you will run into some problems trying to do the paging on
    the server. It gets tough with EJBs. Very inefficient. If you don't have to
    worry a lot about bandwidth, then Matt Chotin's article is a great way to go.
    Even the lazy loading is a good option if you are worried about bandwidth.
    None the less, those articles are ery informative reading :) Hope this helps!

    01merced Guest

  5. #4

    Cool Announcing bigfxlib, an open source Adobe Flex library for handling big data

    Library includes an implementation of ICollectionView and IList that enables client side paging of big data sets while working seemlessly with existing Flex SDK components.

    See https://featurestage.com/bigfxlib
    featurestage Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139