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

[Manuel V. <man...@gm...>]

2006/3/4, Reini Urban <ru...@x-...>:
> Manuel Vacelet schrieb:
> > 2006/3/2, Reini Urban <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.
> >
> > And what about Mysql transaction capabilities via Innodb ?
>
> Then you have to use the mysqlt driver of ADODB and maybe extend the
> PearDB backend to support this. I haven't yet tested it.
> PDO (php5) also fully supports transactions, so should only be used with
> transaction capable database.
>
> Generally, ADODB pulls in all available ADODB drivers automatically.
> So it's great for testing new databases.
> PeadDB needs for every database a special PearDB_<driver>.php file,
> otherwise it will fail to load. This is the conservative and more stable
> backend.

Thank you for all these informations.
I will keep you inform about my tests.

--Manuel