Are you on a network? If yes, have you tried running it from a different machine? If your database is on a network, the swap space that it uses would be in the server rather than on the local machine. With a database this large, disk caching would probably help; you may also try increasing the swap space in you workstation/server.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ramsour Mike Sent: Friday, January 03, 2003 6:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RELOAD slower on 6.5++ In-line patch 3? Actually, I did a test where I did the UNLOAD ALL >> RUN routine and then tried RELOADing and it was still slow. I have not tried an earlier version of R:Base but I think I will. Thanks for the tip, though. Mike Ramsour -----Original Message----- From: Alastair Burr [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 6:37 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: RELOAD slower on 6.5++ In-line patch 3? You could try packing the keys before reloading. Regards, Alastair. ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 11:19 PM Subject: [RBASE-L] - RELOAD slower on 6.5++ In-line patch 3? > Fellowship of the R> > > I have experienced a considerable slowdown in the speed of the RELOAD > command of late. I am running R:Base 6.5++ for Windows on a Windows 2000 > system with a 2 gHz processor and 1 GB of RAM. I have 20+ GB of available > disk space and the combined size of my database hovers around 1.2 GB. When > I first got my new system a couple of months ago reloads took about 10 > minutes, now its taking half an hour or more. Nothing else is running on my > system and the only thing that's really different is that I have crossed the > 1 GB line in the size of my RB2 file. > > If I do an UNLOAD ALL and then RUN the UNLOADEDed files the whole process of > recreating the database, reloading the data and recreating the indexes takes > about 10 minutes. It's just the RELOAD command that's taking a lot longer > now. I thought at first that maybe having a couple of active ODBC > connections to some MS-SQL databases may have been the culprit but I have > SDETACHed and SDISCONNECTed the tables and connections but RELOAD is still > slow. > > Is there something else I should be looking at? I haven't loaded any new > software or changed anything else in my system -- at least not that I can > think of. I'm stumped. > > I have a (possibly) related issue in that my morning routine which consists > of running nearly 100 command files has slowed down from about 50 minutes of > run time to about 2 hours. I have redesigned the way my programs are run by > doing the QUIT TO technique that Razzak recommends but things are still > running slower than at first. I just can't figure out what's going on. > > "Help me Obiwan Kenobi. You're my only hope!" > > Thanks for any and all input. > > Mike Ramsour > Voice: 740-829-4340 >
