2. ASPRunnerPro General questions
  3. Basic database structure question
This topic is locked

Basic database structure question

 		12/20/2006 6:03:11 PM
ASPRunnerPro General questions
author

I have names and addresses in 50 geographical areas, roughly 25,000 per area. What is the best format: 50 separate databases or 50 separate tables in the same database? I am using Access 2003 and the awesome ASPRunnerPRO 4.1. There are about 50 fields in the main name and address table.
Any thoughts/advice welcome.
Sergey Kornilov admin 12/21/2006

I don't see why you need to use more than one table for this purpose.
Maybe you can elaborate it further.
501278 12/21/2006

I don't see why you need to use more than one table for this purpose.

Maybe you can elaborate it further.


One reason to keep them separate is the size of the database - all together there would be about 1.5 million records. If that is manageable and doesn't make the application run slow, I guess I should go that way.
Agree?
Sergey Kornilov admin 12/21/2006

It all depends on your application functionality, database server type, server hardware, number of simultaneous users, database indexes etc.
I would say that with SQL Server or Oracle as a database server, fast server box with 2GB RAM and carefully choosen indexes you'll be fine.

Again, it all depends on what kind of functionality you need to provide.
PS.

If you put data to separate databases user never be able to work with two areas at the same time.