What would be better, (1 database + 4 tables) or (2 databases + 2 tables each) ?
- by griseldas
Hi there,
I would like to be advised on what would be better (in regards to performance)
A) 1 DATABASE with 4 tables
or
B) 2 DATABASES (same server), each with 2 tables.
The tables size and usage are more or less similar, so the 2 tables on Database 1 would be similar usage/size to the 2 tables on database 2
The tables could have +500,000 records and the 2 tables on each database are not related (no join queries etc between them)
Thanks in advance for your comments