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

[Reini U. <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.
-- 
Reini Urban
http://phpwiki.org/
http://helsinki.at/  http://spacemovie.mur.at/