MySQL Help! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Help! (/showthread.php?tid=496501)

---

MySQL Help! - iBeast - 22.02.2014

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 ?

---

Re : MySQL Help! - S4t3K - 22.02.2014

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.

---

Re: MySQL Help! - Vince - 22.02.2014

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.

---

Re: MySQL Help! - iBeast - 22.02.2014

Thanks for the help both of you!
Rep +

---