Some questions on Storage engine
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 helpful if all the temp tables are created with storage engine :MEMORY Thanks, Ratheesh Bhat K J
Re: Some questions on Storage engine
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]
Re: Some questions on Storage engine
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 specification was being ignored in favor of some default--with no error indication, or somebody forgot to document a new feature. This has only been tried by me on Win XP. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]