If you need a "3D" table, couldn't you just use three columns to
describe the X-Y-Z coordinates for the 3D affect? Then use views to
separate the data into different tables.
Bill
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Michael Young
Sent: Wednesday, September 26, 2001 2:00 AM
To: [EMAIL PROTECTED]
Subject: RE: Database limits
Hi Troy,
I might be better off putting it into a few R:Base databases than DBASE
files,
but only testing will tell. I thought the same thing about this and I
have
wracked my brain to get around this many tables but it appears there is
none.
The only way to cut down the number of tables is if we could create a 3
dimensional table and I don't think that is slated for the next version
of
R:Base <G>.
Best regards,
Mike Young
On Tue, 25 Sep 2001 21:34:33 -0600, Troy Sosamon wrote:
>Speed wise using any foreign data source is a lot slower than native
R:base,
>even using the sconnect between R:base database is slow.
>
>700 tables w/ 130 col in each. I think the relational database police
will
>come hunt you down???
>
>Troy
>
>>===== Original Message From [EMAIL PROTECTED] =====
>>Thanks Manuel and Castanaro,
>>
>>Looks like I will probably end up going the DBASE route.
>>
>>Best regards,
>>Mike Young
>>
>>On Tue, 25 Sep 2001 17:21:39 -0700, Manuel de Aguiar wrote:
>>
>>>Hello Mike,
>>>---------------------------------------------------------------------
-------
>-----
>>>Tables/Views/Columns/Rows
>>>
>>>Create up to 16,000 tables or views
>>>Create up to 16,000 columns
>>>Create up to 400 columns (fields) per table or view
>>>Maximum row (record) lengths of 4096 bytes
>>>---------------------------------------------------------------------
-------
>--------
>>>I found this information at:
>>> http://rbase2000.com/Products/rbase.htm
>>>Hope this helps,
>>>Manuel
>>>
>>>Michael Young wrote:
>>>
>>>> Hello,
>>>>
>>>> Does anybody know the limits in terms of number of tables and
columns
>>that
>>>> are allowed in RBWIN 6.5++?
>>>>
>>>> I am looking at developing a database with approximately 700 tables
and
>>around
>>>> 130 columns in each table.
>>>>
>>>> I realize that I may need to use multiple databases but I have
another
>>option and
>>>> that would be to create DBASE tables since there really is no
relationship
>>>> between most of the tables and I can just attach them as needed.
Does
>>anyone
>>>> know the speed or other drawbacks to keeping data in a DBASE file?
>>>>
>>>> Thanks,
>>>> Mike Young
>>>
>
>Troy Sosamon
>Denver Co
>[EMAIL PROTECTED]
>
