Re: [Phpwiki-talk] Better SQL backend for Mysql

[Reini U. <ru...@x-...>]

Manuel Vacelet schrieb:
> I'm about to upgrade my phpwiki installation from 1.3.10 to, at least,
> 1.3.11p1 or upcoming 1.3.12.
> 
> I currently using PearDb backend and I'm reaching -sometimes- speed
> problems (I guess this is due to table locking).

Probably more due to caching, unless you use a real database, not just
mysql. There true transactions gain a lot.
But fastest is by far the dba backend, because of the communication
overhead with the SQL server.

> I started to read Adodb backend sources and it appears that this one
> seems to be better than PearDB, so I have a couple of question:
> * is it possible to switch from a backend to another one ?

sure.

> * should I use Adodb backend instead of PearDb backend ?

why not?

> * how mature/stable is Adodb backend ?

Stable. With 1.3.12_rc2 I see some asymetries in the transaction logs
with postgresql, but it's not critical.

> * is Adodb really faster than PearDb ?

Yes.

> And in a more long term approach:

> * Why keeping 2 backends for the same storage medium ?

We have more than two. PDO is similar, and there are some more.

> * Do you plan to remove one of them ?

No.
-- 
Reini Urban
http://phpwiki.org/
http://helsinki.at/  http://spacemovie.mur.at/