Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What are the limits to the number of tables in a DBC ...
Message
From
24/06/2000 04:06:31
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00384053
Message ID:
00384216
Views:
43
Mike,

>> If you had "a lot" of .DBCs each with "a lot" of tables, it could get painful >to open that page.
>
>I've tested performance with up to 2000 tables. At 1280, it gets painfully slow, something like five minutes. At around 1792, the DBC designer never opens.

Just for my information, how is performance when using such a big DBC in a real time application ??

I guess we don't really need the database designer as when hitting this kind of problems we could also use commands like ALTER TABLE, INDEX ON, PACK DATABASE etc...

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform