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
