…storage engines have very important differences which can affect performance dramatically. The three main issues…are scanned. There are…when this problem is the most dramatic. Some joins are also better than others. For example if you have star join with dimention tables…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…storage engine like Archive… > 3. Using multiple databases Honestly I do not see application using > one database per table…There are many successful applications, using tens of thousands > of tables per host and archiving great performance by doing so. > Using multiple tables…
