Performance Question based on Table Count
Posted: Mon Jul 17, 2006 11:02 am
personally i prefer everything to be small, compact and dead simple. anything that is in my code that doesn't really need to be in there, slows stuff down or just makes it complicated either gets re-written or dumped.
well in light of that i have a serious question about database tables.
does speed decrease with higher count of tables? i think taking tables that can be concatenated should be and should increase speed but now i don't know. i was thinking about it because that would decrease the amount of quieries but that isn't actuallyt he truth. you might still need two anyways.
secondly, if i have two tables and i make one quiery calling two different tables is that like making two queries anyways?
thanx for yout heoretical help
well in light of that i have a serious question about database tables.
does speed decrease with higher count of tables? i think taking tables that can be concatenated should be and should increase speed but now i don't know. i was thinking about it because that would decrease the amount of quieries but that isn't actuallyt he truth. you might still need two anyways.
secondly, if i have two tables and i make one quiery calling two different tables is that like making two queries anyways?
thanx for yout heoretical help