Hi Ben,
Actually I would prefer to keep them in one database but as you have seen in
other posts I am exceeding the number of columns so I am forced to either
use a DBASE file or multiple R:Base databases. Every table will be updated
every day with new data. The tough part is going to be doing the reports. I
will have to check all tables and if they meet certain criteria then I have to
run reports on them. It could be one table or many that I will have to pull
data for reports from. I am guessing about 5% of the tables each day. I will
dump the relevant data into a seperate table and pull the reports from there.
Best regards,
Mike Young
On Tue, 25 Sep 2001 22:50:41 +0100, Ben Petersen wrote:
>Mike,
>
>Sorry for bringing up the obvious... but if the tables have no
>relationships, why not keep separate DBs and connect as needed
>if you prefer not to keep all the tables in a single DB?
>
>Ben Petersen
>
>
>On 25 Sep 2001, at 15:39, 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
>>
>>
>>
>
>
