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 many concurrent queries can mysql handle?

471


What is the difference between unix timestamps and mysql timestamps?

506


What is a deterministic function?

591


What is the usage of ENUMs in MySQL?

633


What is innodb mysql?

487






How to convert character strings to dates?

528


How to print message in mysql trigger?

994


Explain about the architecture of MYSQL?

548


What are triggers mysql?

479


What are the similarities between a function and a procedure?

446


Where does mysql store data?

438


How do I select a database in mysql workbench?

491


What is mysql_pconnect?

456


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2156


How can you make a database as your current database?

498