Re: [Phpwiki-talk] Phpwiki and Mysql slowness

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

2007/1/17, Manuel Vacelet <man...@gm...>:
> FYI, today there is 29000+ pages in our wiki_page table (even if most
> of them are automaticatly created from pgsrc).
>
> > For the next release I will work for sql db's on extracting the standard
> > page and version data properties from serialized blobs into real
> > table columns.
> > This will require more sql schema updates, but I hope action=upgrade
> > will be good enough to do that automatically.
>
> This is very intresting, do you exepect any performances enhancement
> with this upgrade ?
> It could be an opportunity for us to contribute our patch to allow
> several wiki instances to be stored in one table.

It will be a trade-off of the SQL-relation access against a php serialize.
serialize with objects is very slow. Here with the pages and versions
we have only hashes.
I wonder also if it will be worth the trouble.

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