MySQL Help!
#1

Ok, so I was wondering to make a user control panel for my server....
I have experience with PHP a bit.
What I need to know is that for making a user control panel and then connecting it to the script what type of engine should I have for my table?
I mean "InnoDB" or "MyISAM" ?
or both work same ?
Reply
#2

It depends if you plan to use foreign keys or transactions.

If, use InnoDB.
Either, use MyISAM.

The engines always depends of the tables you'll create.
Reply
#3

Even if you don't use foreign key constraints InnoDB seems to be the better choice. Did a quick test just now; table with about 80,000 rows. Fetch a single result. MyISAM took 0.1476 seconds. InnoDB took 0.0236 seconds.
Reply
#4

Thanks for the help both of you!
Rep +
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)