MySQL Forums
Forum List  »  Newbie

Re: A Database within a Database?
Posted by: Barry Galbraith
Date: June 01, 2015 10:36PM

>no need for the DB to call any huge tables that have developed after years of usage.

Size of a table if not as important as having useful indexing on the table. Data retrieval can be instantaneous if the database knows where to look by using an index.

A Relational Database Management System (RDBMS) is really good at doing related data.
If you just want a list of stuff, then perhaps a spreadsheet is the right tool to use.
RDBMS != Spreadheet.
They might look similar, but only because they both use tables. They function very differently.

Here's a good description of how to design a database.
http://www.artfulsoftware.com/dbdesignbasics.html

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
June 01, 2015 07:52PM
Re: A Database within a Database?
June 01, 2015 10:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.