mysql vs mysqli

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

mysql vs mysqli

Post by Burrito »

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
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

I've thought about this but using mysqli stuff will intice me to use mysql features which are not present in other dbms's meaning if I ever decide to leave MySQL for say.. oracle the transfer would be horrid.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

For me the most important advantage is that myqsli allows parameter binding.

(I think that, while MySQL adds support more features it will become slower and slower..
And by the time it supports all the things that postgresql has already i want to see who is the fastest ;)
Post Reply