Bob, Not so good is it? I am going to Chicago (via LA) next Thursday for a three day meeting, maybe I should apply for refugee status in the USA in order to stay away from the NZ Police.
Looks like I'm a bit stuck now. I have done so much programming work in Rbase, I mean there are countless modules that do very clever things, and I would hate to loose all that and have to start converting this to some obscure language like VB or RB. How about using some other database engine let's say mySQL or ORACLE and then use Rbase to talk to it through ODBC could that be a viable option for me to pursue? Anybody out there who has done this? Thanks Frank -----Original Message----- From: Bob Simms [mailto:[EMAIL PROTECTED] Sent: Monday, 15 September 2003 15:22 To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Database capacity constraints? Frank, The size limit is 2 GB per file. Most typically, the limit is reached with the RB2 file, that is, the data file, the RB3 file being used for the indexes. This is a hard limit, and when it is exceeded, your database pretty much turns into hash. This has been my experience. Oterro won't help with this. A question for the dream team: would it be possible to extend the capacity of RBASE databases (in, say, version 7.5) by allowing multiple RB2, 3, and 4 files for a single database? The first version of this scheme might constrain tables to being wholly contained in a single RB2 file. The RB1 file would have to keep track of which RB2 file contains each table, but after that, I/O operations would be the same as before, and best of all, no application programming changes would be required. This could keep users like Frank from having to migrate to some odious Brand X database. . . . Bob S At 11:56 AM 9/15/03, you wrote: >Good morning everybody. > >I developed a system for the NZ Police for criminal profiling in Rbase 6.5+ >This system is going into its 8th year and was originally written as a small >system in 1994 with Rbase 4.5. > >The database consists now of 46 tables with 310 fields. We have currently >loaded 11,743,000 records. One table contains slightly over 4,000,000 >records. > >We tried to add extra data and noticed that the system stops after loading >an additional 470,000 records (approximately). > >Apart from the fact that this is hindering an important piece of work, we >are currently loading an additional 30 - 40,000 records to the database each >month, which implies that we would be running out of space within the next >year. > >Is there a capacity limit within Rbase? Is Oterro a viable alternative? Or >should we go to something like mySQL and use Rbase as a front end through >ODBC? > >Thanks > > >Frank van der Zwaag > > >____________________________________________________________________ >CAUTION - This message may contain privileged and confidential >information intended only for the use of the addressee named above. >If you are not the intended recipient of this message you are hereby >notified that any use, dissemination, distribution or reproduction >of this message is prohibited. If you have received this message in >error please notify Air New Zealand immediately. Any views expressed >in this message are those of the individual sender and may not >necessarily reflect the views of Air New Zealand. >_____________________________________________________________________ >For more information on the Air New Zealand Group, visit us online >at http://www.airnewzealand.com >_____________________________________________________________________ ------------------------------------------------------------ Bob Simms Robert A. Simms and Co., Los Angeles 818-345-5306 Fax 818-345-5136 E-Mail: mailto:[EMAIL PROTECTED] URL: http://www.pacificnet.net/simms ------------------------------------------------------------- ____________________________________________________________________ CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Air New Zealand immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Air New Zealand. _____________________________________________________________________ For more information on the Air New Zealand Group, visit us online at http://www.airnewzealand.com _____________________________________________________________________
