By ryanbasicind@aol.com on

I have a couple of different websites running and i was wondering what is the major differences between the database connections when using mysqli and mysql coding? Will I still be able to run the same modules if I use one and not the other? will it hurt my websites performance?

⋅ Categories: Drupal 5.x, Drupal 6.x

Comments

thmo’s picture

thmo commented

From mysql.com

What is the difference between the mysql and mysqli extensions for PHP?

The mysql extension does not support the full functionality of MySQL versions greater than 4.1.0, such as Stored Procedures, Triggers, Views, Precision Math and much more. In order to use all functions of the latest MySQL Server Releases you have to use the mysqli extension that is available as of PHP 5.0.

The main features of the mysqli extension are:

* access to all MySQL 4.1/5.0 features
* a procedural interface that is similar to the mysql extensions
* an object-oriented interface that is easier to extend than the procedural interface

http://dev.mysql.com/doc/refman/5.0/en/php.html

I would recommend reading some of these articles on zend: http://devzone.zend.com/node/view/id/686 + http://devzone.zend.com/node/view/id/687 They give a decent explanation combined with some code :)

Benchmark wise you can look at: http://www.johnjawed.com/benchmarks/

-----------------------------------------------------------------
They are birds that cannot fly, They are birds that think they're fish.
/penguins

ryanbasicind@aol.com’s picture

ryanbasicind@aol.com commented

Will some modules that drupal offers only support one over the other?