CODEWITHSUNDEEP
phpmysqli
Kerry Jones
Kerry Jones

Reputation: 21848

MySQLi -- OO or Procedural?

I know OO is the "way to go" but I'm thinking procedural might be easier to use in the wrapper I'm making.

Any difference in performance between MySQLi Object Oriented vs Procedural?

Upvotes: 2

Views: 2661

Answers (4)

Lotus Notes
Lotus Notes

Reputation: 6363

This is premature optimization. There's no difference, unless you're really crunching for picoseconds and femtoseconds.

Edit: which you will NOT be crunching.

Upvotes: 7

Travis
Travis

Reputation: 5061

I would suggest checking out the Doctrine Project. They have a great ORM, but if you just want to use the DB abstraction, they've actually separated the DAL out into another project, for people who don't want to use the ORM.

Upvotes: 0

RobertPitt
RobertPitt

Reputation: 57268

The difference is not in regards to MySql or MySqlI but main the fact of using objects over procedural,

Using objects will create reusable code, this being said your applications will be smaller and they tend to have less memory/resource usage.

My Advice is get started with PDO Its an Abstraction layer writter for PHP and is available for several different database servers such as mysql(i)

Read more about the usage here: http://php.net/manual/en/book.pdo.php

Upvotes: 1

Sasha Chedygov
Sasha Chedygov

Reputation: 130877

Not really. There might be a very slight difference, but it's largely negligible. The object-oriented one is, in my opinion, much easier to use, though, even if you are making a wrapper over it anyway.

Upvotes: 1

Related Questions