Mike,
If these tables have identical structures, couldn't you add one more
integer column to ID which ..data set.. this belongs to (1-700) and
manage from there? Just a thought.
Ben Petersen
On 25 Sep 2001, at 23:00, Michael Young wrote:
> 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]
> >
>
>
>
>
