General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Hi Bob!
Borislav showed you that numbers can rise quite high. And at least the help chapter about system capacities says nothing about a limit in the number of tables of a dbc.
Depending on how few fields, indexes, relations and other things stored in the dbc the tables have and depending on creating referential integrity code in the dbc or not the maximum number can get very high. There is pretty much no limit of interest, even if the tables are rather complex, each table requires only few records in the dbc. And I'd suspect, you don't really need referential integrity between so many tables. I'd say the memo file (DCT) would be the first file overflowing, if you defined referential integrity.
Some other limits may be more interesting: You cannot open more than 255 tables at a time in a single datasession. Commands (including sql) cannot be longer than 8192 chars, which could be a problem in this scenario. And you cannot query more than 255 fields of several tables with one select.
Why the need for a high number of tables?
Bye, Olaf.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only