Page 1 of 1

InnoDB Vs MyIsam

Posted: Mon Oct 14, 2019 11:59 pm
by antandt
I have noticed a much faster search if I have my database set up as MyISAM. Is there any reason I should not choose that instead of InnoDB?

Re: InnoDB Vs MyIsam

Posted: Tue Oct 15, 2019 4:05 pm
by captquirk
MyISAM does not support FOREIGN-KEY referential-integrity constraints while InnoDB does.
Such constraints are now an essential part of Sphider 3.3.0.

Re: InnoDB Vs MyIsam

Posted: Tue Oct 15, 2019 4:54 pm
by antandt
Thanks! Right now I am using one of your earlier versions 1.4.2 I think

I may go to 3.3.0 in the future

Re: InnoDB Vs MyIsam

Posted: Tue Oct 15, 2019 9:17 pm
by captquirk
Prior to 3.3.0, user choice! Each has it pros and cons. There are a couple items on the Admin Database tab that are geared towards InnoDb, but that shouldn't be a deal breaker.