Difference between revisions of "Selecting a Database"
From WireCAD Online Help
Wirecadadmin (Talk | contribs) (Created page with "{{PageHeader |shortcut=none |perms=All |level=PRO, ENT |desc=Information on selecting a database type.}}<br>") |
Wirecadadmin (Talk | contribs) |
||
| Line 4: | Line 4: | ||
|level=PRO, ENT | |level=PRO, ENT | ||
|desc=Information on selecting a database type.}}<br> | |desc=Information on selecting a database type.}}<br> | ||
| + | |||
| + | |||
| + | WireCAD v6 PRO allows the use of both file based and server based databases for the project and global databases. The choice of which to use requires some forethought. Listed here are some basic considerations: | ||
| + | |||
| + | {| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%", align="center" | ||
| + | |- | ||
| + | ! Item !! SQL Server !! VistaDB (File Based) | ||
| + | |- | ||
| + | ||Portable || ||align="center"| X | ||
| + | |- | ||
| + | |ACID Compliant (atomicity, consistency, isolation, durability) ||align="center"|X ||align="center"| X | ||
| + | |- | ||
| + | |Database Size || Theoretically unlimited||Theoretical limit is 16 Exabytes (uint64). Practical limit is based upon machine resources. Files are not limited by the database engine, but loading very large databases will require large system resources. | ||
| + | |- | ||
| + | |In Process Processing || ||align="center"| X | ||
| + | |- | ||
| + | |||
| + | |} | ||
Revision as of 02:10, 23 December 2010
| Command Line Shortcut: none User Permissions Level: All |
WireCAD v6 PRO allows the use of both file based and server based databases for the project and global databases. The choice of which to use requires some forethought. Listed here are some basic considerations:
| Item | SQL Server | VistaDB (File Based) |
|---|---|---|
| Portable | X | |
| ACID Compliant (atomicity, consistency, isolation, durability) | X | X |
| Database Size | Theoretically unlimited | Theoretical limit is 16 Exabytes (uint64). Practical limit is based upon machine resources. Files are not limited by the database engine, but loading very large databases will require large system resources. |
| In Process Processing | X |
