InnoDB Vs MyIsam

Come here for help or to post comments on Sphider
Post Reply
antandt
Posts: 2
Joined: Mon Oct 14, 2019 11:53 pm

InnoDB Vs MyIsam

Post 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?
User avatar
captquirk
Site Admin
Posts: 299
Joined: Sun Apr 09, 2017 8:49 pm
Location: Arizona, USA
Contact:

Re: InnoDB Vs MyIsam

Post 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.
antandt
Posts: 2
Joined: Mon Oct 14, 2019 11:53 pm

Re: InnoDB Vs MyIsam

Post 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
User avatar
captquirk
Site Admin
Posts: 299
Joined: Sun Apr 09, 2017 8:49 pm
Location: Arizona, USA
Contact:

Re: InnoDB Vs MyIsam

Post 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.
Post Reply