How can I split big recordsets into smaller ones


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How can I split big recordsets into smaller ones

  1. #1
    Joar Vatnaland Guest

    How can I split big recordsets into smaller ones


    I am working on a solution where I use ADO against an Oracle database. I
    want to send a query, get back a recordset, save it as xml, and give the
    client the reference to the xml file.

    The problem is, the resulting recordset could potentially be very large,
    which would give the client a lot of download time and maybe memory problems
    as well.

    Is there a simple way of partitioning the recordset if it is over a certain
    size, say if you get back 7430 records, you could make 7 files a 1000 records
    and one with 430?

    Or if you have suggestions for a better design, I am all ears!

  2. #2
    Brian Guest

    Re: How can I split big recordsets into smaller ones

    I would use the GetRows method of the recodset object. This returns an
    array of records. Determine how big the parent array is and split it into a
    number of child arrays of your prefrence.

    "Joar Vatnaland" <joar@synopsys.co.uk> wrote in message
    news:3a41ddec$1@news.devx.com...
    >
    > I am working on a solution where I use ADO against an Oracle database. I
    > want to send a query, get back a recordset, save it as xml, and give the
    > client the reference to the xml file.
    >
    > The problem is, the resulting recordset could potentially be very large,
    > which would give the client a lot of download time and maybe memory

    problems
    > as well.
    >
    > Is there a simple way of partitioning the recordset if it is over a

    certain
    > size, say if you get back 7430 records, you could make 7 files a 1000

    records
    > and one with 430?
    >
    > Or if you have suggestions for a better design, I am all ears!




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center