Albert, I am not using 4.5 but 6.5++ with Win2000 Pro. I have been trying to flip the values of two columns for 90,000 rows of data using an update call within a cursor after I have captured the two values in two variables. The problems that I have is almost exactly the same same as Steven has stated. After processing about 20,000 rows (390 bytes/row), I get the message: I have a message telling me that the machine is out of Virtual memory and that I should try increasing the size of the paging file. I too have set all my file and buffers to the max. I run a 1.7Ghz Processor and have in excess of 30 GB of physical and max on memory. To counter the problem (slows down to a slug pace), I hit the ESC key and it asks me if I want to cancel the command (RMD processing). I answer yes and close down RBase. I then reopen RBase and run the RMD again and it takes off very fast for about 20,000 rows. Finally my question: To counter this memory leak, can I put a counter in the code that will count until 15,000 then launch the RETURN /C EXIT. If you do that, doesn't that take you out of RBase? Then how do you get back in?
Phil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Albert Berry Sent: Wednesday, January 23, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: RE: RB4.5++ with Win2K Steven - the memory leak persistence is a chronic problem with W2K. We have added in our menu loops a small command file that checks for the (ENVVAL('COMSPEC')), and if it contains 'WINNT' we do a ZIP RETURN /C EXIT to free up the memory. We add a pause 3 to tell the user why he/she is losing 3 seconds of their life. They don't like it, but the alternative is worse, so they accept it. Steven Hoggan <[EMAIL PROTECTED]> wrote: >Hello all, > >I apologise profusely in advance for losing my Rbase message archive, but I >need help in setting up a Win2000 Pro desktop to run Rbase 4.5++ > >I have a set of database maintenance routines that run quite happily forever >and a day under W95/W98. > >Win2000 Pro, however, crashes to the R> periodically, however, and in the >background I have a message telling me that the machine is out of Virtual >memory and that I should try increasing the size of the paging file. > >The details as I have them: > >System stuff >------------------ >Dell Dimension 4300 >256MB RAM >100GB HDD >Win2000 Pro >Paging File set to 512MB Initial, 768MB Maximum > >System Variables >Files=60 >Buffers=60 >TEMP=C:\WINNT\TEMP >TMP=C:\WINNT\TEMP >(the above directory definitely exists) > >No User Variables > >Rbase Stuff >---------------- > >Rbase Icon settings: >CMD Line: H:\RBASE45.BAT >Memory settings; All Auto > >Contents of H:\RBASE45.BAT >SET ERR MESS OFF >SET MESS OFF >SET MULTI ON >SET CASE OFF >SET LINEEND = '^' >SET ROWLOCKS ON >CD .. >DISC >SET SORT MAX 64 >SET FILES 20 >H: >CD \ >RUN STARTSYS.MAC > >My Rbase.DAT files has the following 2 settings >SET FILES 20 >SET SORT MAX 64 > > >Hopefully there's enough there for the experts among you to analyse and >improve upon. > >TIA, > >Steven > > > > > > > > >Confidentiality Notice >---------------------- > >This message and any attachments is confidential and may contain privileged >information. It is intended only for the identified recipient. Anyone else >must not copy, use, store or disseminate it. If you are not the intended >recipient, please email it back to the sender and then delete it from your >mail system. Thank You. Fitzpatricks. > >Tel: +44 (0)141 306 9000 >Fax: +44 (0)141 306 9090 >Web: www.fitzpatricks.co.uk >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
