var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Best approach to DB structure?
I am creating a web-based database application and need yoru thoughts on the best structure for the DB tables to allow best functionality and reasonable speed. Here are the details:
Access 2003 database
About 1.5 million records arranged by geographic regions of the state
About 30,000 records for each of 50 regions
About 50 fields in main table
Set up 50 separate databases?
Set up 50 separate tables in the same DB?
Set up one main DB table?