RE: VB and Oracle...memory limiting the amount of records returned?
Hi Chris, I'm not sure I understand the problem, but we have VB apps that routinely retrieve tens of thousands of records at a time, and occaissionally more, if that helps. We have not run into any limitation. If you want to send me more details on the problem I'd be happy to try to help. Beth -Original Message- Sent: Friday, June 14, 2002 4:44 PM To: Multiple recipients of list ORACLE-L We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VB and Oracle...memory limiting the amount of records returned?
We have a similar problem with a vendor supplied application. We solved it (at least we masked the symptom) by increasing the ODBC timeout in the user's W2K registry. The vendor app uses an ODBC connect to a CORBA broker (OpenLink) on the server. It's a bank rec that was only returning a portion of the payroll checks issued. David A. Barbour AISD Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcg. cc: com Subject: VB and Oracle...memory limiting the amount of records Sent by: returned? [EMAIL PROTECTED] om 06/14/2002 03:43 PM Please respond to ORACLE-L We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).