Selecting a Database
From WireCAD Online Help
Revision as of 02:10, 23 December 2010 by Wirecadadmin (Talk | contribs)
| 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 |
