what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?

Answer Posted / zubair bit

innoodb has maximum performance for large databases

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a database in mysql workbench?

449


what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

533


What are date and time data types in mysql?

524


Where is the mysql config file?

473


What's new in mysql 8?

568






What is mysql community edition?

518


Why mongodb is faster than mysql?

475


Can't connect mysql server on localhost?

509


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1168


How do I install mysql workbench?

484


Is oracle better than mysql?

473


How can I insert images into a Mysql database?

571


What is a mysql model?

501


How do I change the max connection in mysql?

519


How to create a new table by selecting rows from another table in mysql?

504