You should have no problem with 2+g datafiles. The Rbase site shows the file size limits is in the TB range not gigabyte
Mark Lindner Lindner & Associates PC 254 Second Ave Needham MA 02494 781 247 1100 Fax 781 247 1143 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dee Georgeson Sent: Thursday, April 08, 2010 1:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size Gentle People, I would like to reopen this issue since no one actually answered the question. Let me ask it directly: Is there a file size limitation to the database files in Rbase Turbo V8? I believe the answer to be yes based on the following information. Would someone please confirm? Computer Specifications: Intel(r) Core (tm) CPU 6600 @2.4GHz 2.00GB RAM 32-bit Operating System Windows Vista(tm) Business SP 2 I am running R:base Turbo V-8 Build 8.0.22.30331 Hard Drives: C: 74.5GB, 53.6GB used, 20.8GB free D: 38.2GB, 21.8GB used, 16.3GB free The database is on the D: drive. Starting Database File Size: 04/08/10 09:39 AM 272,404 earl.RX1 04/08/10 09:39 AM 2,228,224,000 earl.RX2 04/08/10 09:39 AM 1,510,752,256 earl.RX3 04/08/10 09:39 AM 7,983,104 earl.RX4 History Table Specifications: No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 HID Type : INTEGER NOT NULL AUTONUMBER Consrnt: PRIMARY KEY REFERENCED 2 PartRef Type : INTEGER Consrnt: FOREIGN KEY REFERENCES Invent 3 PartNo Type : TEXT 50 Index : SINGLE-COLUMN 4 SerialNo Type : TEXT 15 Index : SINGLE-COLUMN 5 Status Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Status 6 DocNo Type : TEXT 12 Index : SINGLE-COLUMN 7 DocType Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES DocType 8 Qty Type : INTEGER 9 PrevAssn Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Assignment 10 CurAssn Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Assignment 11 PrevLoc Type : TEXT 16 Index : SINGLE-COLUMN 12 CurLoc Type : TEXT 16 Index : SINGLE-COLUMN 13 WoSeg Type : TEXT 4 14 TranDate Type : DATE 15 TranAmt Type : CURRENCY 16 ReqNoItem Type : TEXT 10 Index : SINGLE-COLUMN 17 Notes Type : NOTE 18 LastStatus Type : TEXT 1 19 EmpNo Type : TEXT 9 Consrnt: FOREIGN KEY REFERENCES Employee 20 DTStamp Type : DATETIME Index : SINGLE-COLUMN Current number of rows: 3,106,019 I set messages on, error messages on, and feedback on. I execute this command: alter table history alter column tranamt real The rows update successfully. Rows then start collecting for Index Creation. Feedback doesn't show which index is being created. After many indexes are created the program stops with this error message: -ERROR - Unable to create/modify table (2832) File sizes after disconnecting from the database: 04/08/10 10:06 AM 277,906 earl.RX1 04/08/10 10:06 AM 2,980,267,268 earl.RX2 04/08/10 10:06 AM 2,147,484,672 earl.RX3 04/08/10 10:06 AM 7,983,104 earl.RX4 Since the error message doesn't tell me anything about why it couldn't modify the table, I'm left to assume that there is a file size limitation to these files. If this isn't the case, please tell me what is happening. Thank You for your consideration. Dee Georgeson Erickson Air-Crane Inc -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, February 12, 2010 5:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size At 04:37 AM 2/12/2010, Doug Hamilton wrote: >The file size "limitation" is a function of the 64 bit implementation, >regardless of the name of the file. Doug >p.s. That means even the RX1 could be > 2Gb. However, one may want to >review their db structure in that case :) . Implementation of 64-bit data pointers in Turbo V-8 . Ability to name INDEXes up to 128 Characters http://www.rbase.com/products/compare.php In addition, I would be curious to see the LIST of INDEXes, PKs, FKs, and UKs in that particular Turbo V-8 database. CONNECT dbname IDENTIFIED BY ownername user SET NAMEWIDTH 40 SET LINES 0 LIST INDEX LIST PKeys LIST FKeys LIST UKeys Very Best R:egards, Razzak. P.S. http://www.rbase.com/rbg90/compare.php
