Is there any advantage by setting a filed, fixed or variable length. In my application there are somany deletion and modification of records. Will Fixed/Variable Property affect my programs performance or database size?
Printable View
Is there any advantage by setting a filed, fixed or variable length. In my application there are somany deletion and modification of records. Will Fixed/Variable Property affect my programs performance or database size?
Assuming that the data is variable length, a variable length data type is best - it takes less space in the database, and requires less memory/network usage (which could both potentially affect performance).