Hello All,
I don’t know if I should add to an existing database or create additional ones.
This is what I have:
content.mdb (holds all site html/txt content) 2,685 KB, heavy use
site.mdb (admin and configuration settings) 724 KB, light use
users.mdb (user accounts and form data) 1,429 KB, moderate use
vnpos.mdb (sales and purchase data) 761 KB, moderate use
vncrt.mdb (product and store data) 512 KB, moderate use
If an average user session will hit most if not all of these databases would it be more efficient to combine some of them (less db’s but larger sizes) or is many smaller ones better?
Cheers
mossimo
I don’t know if I should add to an existing database or create additional ones.
This is what I have:
content.mdb (holds all site html/txt content) 2,685 KB, heavy use
site.mdb (admin and configuration settings) 724 KB, light use
users.mdb (user accounts and form data) 1,429 KB, moderate use
vnpos.mdb (sales and purchase data) 761 KB, moderate use
vncrt.mdb (product and store data) 512 KB, moderate use
If an average user session will hit most if not all of these databases would it be more efficient to combine some of them (less db’s but larger sizes) or is many smaller ones better?
Cheers
mossimo