bamfon Posted January 12, 2011 Share Posted January 12, 2011 What will make the database take longer to load and pull data from it A database with lots of tables or a database with very few tables but a shit load of data in each table? Thanks for your reply Quote Link to comment Share on other sites More sharing options...
joel24 Posted January 12, 2011 Share Posted January 12, 2011 if you had lots of tables then you would be incorporating a lot of joins or numerous commands, which would in effect be the same if not more power intensive as having one tables with many rows. Keep your tables focused to their task, don't go trying to slim down the DB by making one table keep several tasks data and mysql is developed to handle huge databases with millions of rows Quote Link to comment Share on other sites More sharing options...
bamfon Posted January 12, 2011 Author Share Posted January 12, 2011 Thanks for the reply also would 54 tables in a database be a lot Quote Link to comment Share on other sites More sharing options...
Rayhan Muktader Posted January 12, 2011 Share Posted January 12, 2011 No 54 tables cannot be called "a lot". If you are worried about load time then you should query and join using primary keys. Quote Link to comment Share on other sites More sharing options...
Maq Posted January 12, 2011 Share Posted January 12, 2011 What will make the database take longer to load and pull data from it A database with lots of tables or a database with very few tables but a shit load of data in each table? Thanks for your reply Sounds like you're asking if you should use a relational database or not? Most likely yes, but in some cases no. Depends on what exactly you're trying to do. Quote Link to comment Share on other sites More sharing options...
bamfon Posted January 12, 2011 Author Share Posted January 12, 2011 one last question How many tables would come under having a lot of tables? Quote Link to comment Share on other sites More sharing options...
Maq Posted January 12, 2011 Share Posted January 12, 2011 one last question How many tables would come under having a lot of tables? That's relative to what you're working on. Check out - Database Normalization. Quote Link to comment Share on other sites More sharing options...
phil88 Posted January 12, 2011 Share Posted January 12, 2011 Depends on the system. 54 tables for a basic blog system? That's a hell of a lot. But 54 tables for a system that incorporates forums, blog, comments, users, profiles, photo albums etc. is not a lot. Quote Link to comment Share on other sites More sharing options...
bamfon Posted January 13, 2011 Author Share Posted January 13, 2011 Thanks for the reply everyone it has been a lot of help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.