Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One or two databases
Message
De
19/01/2000 10:46:03
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00319889
Message ID:
00319911
Vues:
10
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform