Joins between InfiniDB and MyISAM/InnoDB

2 posts / 0 new
Last post
samc
samc's picture
Offline
Last seen: 3 years 9 months ago
Joined: Apr 3 2010
Senior Boarder

Posts: 23

Sam Crawford
Joins between InfiniDB and MyISAM/InnoDB

Hello,

I'm trying to migrate system developed on Symfony and Doctrine from InnoDB to InfiniDB. Because of different limitations of InfiniDB like foreign keys, data types and other the process is quit complex.

So, I would like to know if there is any way to make joins between InfiniDB and MyISAM/InnoDB.

Thank you.

davidhill
davidhill's picture
Offline
Last seen: 1 month 4 days ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:Joins between InfiniDB and MyISAM/InnoDB

It is possible to join tables between InfiniDB and MyISAM/InnoDB using the Operating Mode as documented in the Syntax Guide, section Operating Mode.

Setting infinidb_vtable_mode = 0 will allow the joins to work.

[b]BUT this means that all of the query processing will by done by MyISAM performing row-by-row processing. So you will not be receiving any of the performance benefits from InfiniDB.[/b]

So if there is a small case where you need to do this, this might be OK. But doing it across a large sample of data, as stated, you aren't utilizing the performance from InfiniDB.