Ratheesh K J wrote:
Hello all,
I have a couple of questions on storage engine types wrt performance
1.. Will there be any performance degrade when we do "joins with tables having
different storage engines" ?
Depends on the type of queries I think.
There could be something here
http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html
or even
http://dev.mysql.com/doc/refman/5.1/en/select.html
2.. Where are the temporary tables created? (by default why not memory
storage engine?) will it be helpful if all the temp tables are created with
storage engine :MEMORY
You can't store them in memory.
http://dev.mysql.com/doc/refman/5.1/en/temporary-table-problems.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]