Trends Feature Optimizing Performance on Public Domain Databases PAGE 3 OF 8 Numeric fields offer many advantages.
Numbers are much less likely to be used incorrectly.
And numeric joins are more efficient than character-based joins. It is good practice to create a numeric primary key field whenever you are creating a new table. Optimizing Code Several strategies can be used within your code to optimize its performance when dealing with a database. The following optimization should be usable in any Web development language. Avoid Using Sessions Several Web development environments support sessions.