mysql vs mysqli
Posted: Fri Nov 18, 2005 11:08 am
I wanted to open a discussion about the differences between these php function sets.
My goal with this discussion is to determine if moving to mysqli is in my best interest at this point. What I want to know is, for those of you who have made the switch, for what purpose did you make the switch? I realize that mysql has some limitations with the newer versions of MySQL (from 4.1 and beyond is my understanding). Beyond stored procs and the like, what are the limitations that the mysql function set has of which mysqli takes advantage?
Yes I understand that I can use objects for mysqli but after reading the documentation about it, in a way it almost seems more convoluted than beneficial to use objects in the manner in which it was designed. I also understand that I won't be required to use mysql_real_escape_string with mysqli, but to me that's not a huge issue.
I did a little bit of research and found this benchmark test between the two sets: http://www.johnjawed.com/benchmarks/ and from what I gather, using mysqli in the standard way is actually slower than mysql.
So, if you have some insight to the differences, please share.
thanks,
Burr
My goal with this discussion is to determine if moving to mysqli is in my best interest at this point. What I want to know is, for those of you who have made the switch, for what purpose did you make the switch? I realize that mysql has some limitations with the newer versions of MySQL (from 4.1 and beyond is my understanding). Beyond stored procs and the like, what are the limitations that the mysql function set has of which mysqli takes advantage?
Yes I understand that I can use objects for mysqli but after reading the documentation about it, in a way it almost seems more convoluted than beneficial to use objects in the manner in which it was designed. I also understand that I won't be required to use mysql_real_escape_string with mysqli, but to me that's not a huge issue.
I did a little bit of research and found this benchmark test between the two sets: http://www.johnjawed.com/benchmarks/ and from what I gather, using mysqli in the standard way is actually slower than mysql.
So, if you have some insight to the differences, please share.
thanks,
Burr