How can I split big recordsets into smaller ones

[Joar Vatnaland]

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!

[Brian]

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!