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 » Mon Oct 14, 2019 11:59 pm

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: 122
Joined: Sun Apr 09, 2017 8:49 pm
Location: Arizona, USA
Contact:

Re: InnoDB Vs MyIsam

Post by captquirk » Tue Oct 15, 2019 4:05 pm

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 » Tue Oct 15, 2019 4:54 pm

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: 122
Joined: Sun Apr 09, 2017 8:49 pm
Location: Arizona, USA
Contact:

Re: InnoDB Vs MyIsam

Post by captquirk » Tue Oct 15, 2019 9:17 pm

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