Thanks,
Chris
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:08 PM
To: CF-Talk
Subject: Re: CF5: Oracle recordset via StoredProc and QofQ questions
Lofback, Chris wrote:
>
> 1) Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure? Is it slow? Unstable/flaky?
250,000 * 10 * 50 = 125 MB minimum
It needs to be stored in RAM.
> 2) Can QofQ handle a recordset that large?
If you have the RAM. Remember that with every QoQ you create a
new recordset that needs to be stored in RAM. Plus the output
page needs to be stored in RAM.
I would rethink and try to do more in the DB.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
