MyBB Community Forums

Full Version: Mysql or Mysqli. Whats the difference?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Well I have my forums with mysql, but I hear that MySQLi is better but,

What´s the difference on MyBB on performance? Fewer querys to the database? Fewer memory consumption or CPU?

What recommend for use and why?

And How can I Change for MySQL to MySQLi?


Thanks.
I'm not really sure on the exact benefits but if your host has it installed you can change mysql to mysqli in ./inc/config.php and everything should work fine.
It should give you better performance. It doesn't reduce the number of queries, but it just is an improved version of the underlying API that is used to communicate with the MySQL server.
(2009-06-18, 03:16 PM)rafaweb Wrote: [ -> ]Well I have my forums with mysql, but I hear that MySQLi is better but,

What´s the difference on MyBB on performance? Fewer querys to the database? Fewer memory consumption or CPU?

What recommend for use and why?

And How can I Change for MySQL to MySQLi?


Thanks.

In addition, have a look at this article.

http://dealnews.com/developers/php-mysql.html
Ok, Thanks Guys, the difference is not great but maybe better...