Posted by james on 11/06/07 19:31

On Nov 5, 8:48 am, Michael Fesser <neti...@gmx.de> wrote:
> .oO(ja...@jgoode.co.uk)
>
> >I've written my own database class using PHP's mysql functions, rather
> >than using mysqli, and I've added functions to automatically get,
> >insert and update.
>
> The old MySQL extension misses some really important features like
> prepared statements and native transaction support.
>
> >In the end, it's a lot faster than the built-in
> >mysqli, and it didn't take long to write.
>
> Did you test that? Your wrapper class is written in PHP, while the
> MySQLi and PDO extensions are written in C and directly call the MySQL
> API. Of course there will be some overhead because of the advanced
> features (especially in PDO), but I doubt that this makes much of a
> difference. What really counts are the queries sent to the DB and the
> table structure, not the used interface (IMHO).
>
> Micha

Just to clarify my previous post; by faster, I meant the process of
writing code is faster, not the speed at which database actions are
performed, for instance, my class includes a 'get' function, and
$array = data::get('blog_entries') would fetch all of the posts in the
table blog_entries.

[Back to original message]