Re: Are tables independent?
I use InnoDB; and the size of my tables or the entire database is far lesser than the filesystem limit.
By the sentence "mysql query is merely within table level, without considering the entire database (other tables indeed)", I mean when we run a query within a single table (like SELECT), does it matter how big is the database?
For example, imagine SELECT from a table with one row. Is this query different (its speed, resource usage, etc) when the database size is 1MB OR 1TB ? The table size is the same in both cases!
Subject
Written By
Posted
February 24, 2012 12:13PM
February 24, 2012 06:08AM
February 24, 2012 03:49PM
February 24, 2012 04:31PM
Re: Are tables independent?
February 25, 2012 12:28AM
February 25, 2012 04:58AM
February 26, 2012 04:39PM
February 26, 2012 08:00PM
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.