RE: VB and Oracle...memory limiting the amount of records 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 Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).




-- 
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 Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).
-- 
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 Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).