| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: VB and Oracle...memory limiting the amount of records returne
Similar to what David did, I always uncheck the 'Enable Query Timeout' option box on the ODBC DSN. Like David, we found that a long query would timeout and drop the ODBC connection before any data was returned to the calling program.
Beth
-----Original Message-----
Sent: Monday, June 17, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
returne
Hey David,
Thanks for replying.
So increasing the ODBC timeout was chosen versus increasing the memory
of
the PC??
I know Oracle not VB, so Im generalizing here when I'm assuming that all
this data is being loaded into a array into memory, which is why the PCs
are
running out of memory. And when they added more memory they were able
to
retrieve more records.
Do you have any details as to why increasing the timeout solved the problem?
Many thanks!!!
Chris
-----Original Message-----
[mailto:DBarbour_at_austin.isd.tenet.edu]
Sent: Friday, June 14, 2002 10:03 PM
To: Multiple recipients of list ORACLE-L
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 <ORACLE-L_at_fatcity.com>
<cgrabowy_at_fcg. cc:
com> Subject: VB and
Oracle...memory
limiting the amount of records
Sent by: returned?
root_at_fatcity.c
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: cgrabowy_at_fcg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: DBarbour_at_austin.isd.tenet.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Mon Jun 17 2002 - 10:13:25 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |