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 ?
2.. Where are the temporary tables created? (by default why not memory
storage engine?) will it be
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
At 10:20 PM 8/22/2006, Chris wrote:
You can't store them in memory.
http://dev.mysql.com/doc/refman/5.1/en/temporary-table-problems.html
Despite what the doc says, I posted a working script here a couple of weeks
ago which creates temporary tables with engine=Memory. Either my