InnoDB Vs MyIsam
InnoDB Vs MyIsam
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
MyISAM does not support FOREIGN-KEY referential-integrity constraints while InnoDB does.
Such constraints are now an essential part of Sphider 3.3.0.
Such constraints are now an essential part of Sphider 3.3.0.
Re: InnoDB Vs MyIsam
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
I may go to 3.3.0 in the future
Re: InnoDB Vs MyIsam
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.