myisam or innodb? how would you decide?

[Jassim Rahma]

Hi, I would like to ask how would you decide if you are developing a hospital management software using C# .NEt and MySQL if you should go for myisam or innodb? Thanks,

Technology News @ www.JassimRahma.com

[Lost User]

Jassim Rahma wrote:

a hospital management software using C# .NEt and MySQL

Why MySQL if you're using C#? What platform are you on?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[jschell]

InnoDB You would only choose myisam if you have very specific requirements and if you analyzed the difference and determined that InnoDB would make it impossible.

[Lost User]

Neither, I would start by doing a proper review and analysis of the requirements and then decide which database system would have the features and power to support it. And for a hospital system I doubt that anything less than Oracle or SQL server would be sufficient. It is never a good idea to design your system so that it fits your choice of database and development language.

Use the best guess