29 Oct
2017
29 Oct
'17
11:18 p.m.
On 2017-10-28 11:54, Stephen Russell wrote:
Disk space is cheap. Database schema changes are not. Updates require testing as well as validation in all of the UI and UX environments.
Indexes of int are easy and great. Indexes of Char, VarChar, or NVarChar are necessary. How the rdbms does such, and how the dba defines the index to accept insert as well as an update is where the true performance lies.
FabNet was designed with app-generated GUIDs using Craig Boyd's createguid logic. Classic FabMate was using auto-incrementing tables in VFP; I was thinking of just using auto-inc keys again (rather than varchar(40) guid keys).