07-16-2009, 07:59 AM
[eluser]timaksu[/eluser]
this is mainly a mysql question but im using it in a codeigniter application..anyway..i have a single database table that handles most of my website "Content". this mainly includes things like regular site comments (to news posts etc), blog posts, blog post comments etc. i was wondering if their would be a performance issue here. would it make a different to store comments in the comment table and blog posts in the blog table rather than having both in the same one? i like the way i have it now. it works well for my system. so if there isnt a huge problem i would like to leave it unchanged.
this is mainly a mysql question but im using it in a codeigniter application..anyway..i have a single database table that handles most of my website "Content". this mainly includes things like regular site comments (to news posts etc), blog posts, blog post comments etc. i was wondering if their would be a performance issue here. would it make a different to store comments in the comment table and blog posts in the blog table rather than having both in the same one? i like the way i have it now. it works well for my system. so if there isnt a huge problem i would like to leave it unchanged.
