HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Benefits of mySQLi driver?

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#73771 (In Topic #15412)
Avatar

Community saint

I did a fresh install today and noticed the choice of using either the traditional mySQL driver or mySQLi driver. I am curious if anyone has used the mySQLi driver and found there to be any performance benefits.

Thanks for any info.

Bob
Back to the top
 
Posted
Rating:
#73950
Avatar

Community saint

Wel, looks like they have been no brave souls to test the mySQLi driver. Am I correct that it is as simple as changing the db_type in the config editor to mysqli? If so, I may test this out on  my development site.

I'd still like to hear from anybody who has already tested or is using the mySQLi driver. It doesn't look like ocPortal is taking advantage of any of its features yet but I read a couple of places that it should be a bit faster than the traditional driver. Of course, you can't believe everything you read online.

Bob

Back to the top
 
Posted
Rating:
#73957
Avatar

ocStaff (admin)

I'd stick to 'mysql'. It's the one we use by default when developing/testing.

mysqli will be slightly faster, but developers would only notice if hand coding snippets of PHP into HTML pages (i.e. bare bones coding, night and day performance profile compared to a CMS).



Become a fan of ocPortal on Facebook or add me as a friend.

Expand: Was I helpful? Was I helpful?

Expand: Follow me on Twitter Follow me on Twitter







If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource.
Back to the top
 
Posted
Rating:
#73965
Avatar

Community saint

Gotcha. Will stay with the tried and true.

Thanks for the reply.

Bob
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: