There's absolutely no way that anybody using OpenMRS should use MyISAM, since it doesn't support transactions.
-Darius On Wed, Aug 17, 2011 at 11:26 AM, Wyclif Luyima <[email protected]> wrote: > You may wish to look at these posts about InnoDB vs MyIsam > > http://mikebernat.com/blog/MySQL_-_InnoDB_vs_MyISAM and > http://www.kavoir.com/2009/09/mysql-engines-innodb-vs-myisam-a-comparison-of-pros-and-cons.html > > Probably full text indexing with MyISAM is what slows it down when it comes > to the indexing query you tested against. > > Wyclif > > > On Wed, Aug 17, 2011 at 1:41 PM, Jeremy Keiper <[email protected]> wrote: > >> Has anyone used the MySQL InnoDB plugin [0] for performance enhancement >> (faster indexing, etc)? >> >> I just tried it out in our dev environment for upgrading the AMPATH >> dataset from version 1.6.2 to 1.8.2. Our original upgrade was stuck on >> adding an index to the obs table for 4+ days. After installing the plugin, >> the same statement completed in 24 minutes. I would like to continue using >> it, but need to know if anyone else has experienced problems with it. I >> will post a blog entry with my findings. Thanks! >> >> [0]: http://dev.mysql.com/doc/innodb-plugin/1.0/en/index.html >> >> Jeremy Keiper >> OpenMRS Core Developer >> AMPATH / IU-Kenya Support >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >> OpenMRS Implementers' mailing list > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
