Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One or two databases
Message
From
19/01/2000 10:46:03
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00319889
Message ID:
00319911
Views:
11
>Opinions, comments, general feelings on simple question.
>Should I have one big DBC or two medium DBCS in one big system with many users?
>One with all tables (Lookups and Data)? Or two separate ones. Data tables in one DBC, lookup tables in the other. The system usually involves opening only one or two forms at the most (multiple tabs).
>
>Speed, integrality, optimization, standardization (whatever that is). Any thoughts


IMHO it's totally up to your taste. Lookup tables generally doesn't have any referential integrity nor need extended DBC capabilities, therefore could even be free tables. If you'll contain them in a DBC making it another DBC would mean you could easily share them with other projects.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform