phpwiki-talk

[Phpwiki-talk] ADODB support

[Lawrence A. <Law...@th...>]

I have checked into cvs a first cut of an ADODB backend.  I've only 
tested this on MySql.  I still have some work to do on error handling 
etc, but it seems to work fine for me.  If you want to try it out, use 
'dbtype' => 'ADODB' in index.php

Please let me have any comments.  If you can do any benchmarks, 
that would be great.  My impression is that it is faster than PEAR, but 
that's rather unscientific.  In any event, the code needs some tightening 
anyway, so it is likely to prove faster still.

It doesn't suffer from the backslash bug!

Lawrence--------------------------------------------------------
Confidentiality Notice

The information contained in this e-mail is confidential.  It is for the
use of the named recipient only.  If you are not the named recipient, 
please destroy and do not disclose the contents of this e-mail
to any other person, or copy it.  Thank you for your co-operation.

Re: [Phpwiki-talk] ADODB support

[Carsten K. <car...@ma...>]

Lawrence,

I tested the ADODB by adding a debug argument to the AllPages plugin, 
which tells you how long it took to generate the list.

AODB was up to twice as fast, and subsequent reloads of AllPages seemed 
quicker. (Is that possible--does it have better cacheing or something?) 
Mac OS X 10.1.2, mysql-3.23.44, php 4.1, Apache/1.3.22.

We're talking about less than a quarter of one second of improvment 
loading AllPages on my system, but it does seem (barely) noticeably faster.
  I wonder what the speed difference would be like on the SourceForge 
phpwiki.

Carsten

On Friday, February 1, 2002, at 07:00  pm, Lawrence Akka wrote:

> Please let me have any comments.  If you can do any benchmarks,
> that would be great.  My impression is that it is faster than PEAR, but
> that's rather unscientific.  In any event, the code needs some tightening
> anyway, so it is likely to prove faster still.
>
> It doesn't suffer from the backslash bug!
>
> Lawrence--------------------------------------------------------

RE: [Phpwiki-talk] ADODB support

[Pablo R. <pr...@cl...>]

> AODB was up to twice as fast, and subsequent reloads of=20
> AllPages seemed=20
> quicker. (Is that possible--does it have better cacheing or=20
> something?)=20
> Mac OS X 10.1.2, mysql-3.23.44, php 4.1, Apache/1.3.22.

> We're talking about less than a quarter of one second of improvment=20
> loading AllPages on my system, but it does seem (barely)=20
> noticeably faster.
>   I wonder what the speed difference would be like on the SourceForge=20
> phpwiki.

Carsten,

In some tests I done ADODB is three times faster than PEAR. I can send
this test to any who like.

And yes ADODB can have a cache system, but I guess that Lawrence didn't
throw this yet to the CVS, so expect more improvement when this cache
system is committed. Am I right Lawerence? Didi you put yet the ADODB
cache?

Anyway, ADODB is technically better done than PEAR, and supports more
databases.

Right decision Lawrence! Congrats!

Saludos,

Pablo Roca MS - VFP MVP
La Coru=F1a - Espa=F1a

Re: [Phpwiki-talk] ADODB support

[Steve W. <sw...@pa...>]

Very cool, Lawrence!

~swain

On Sat, 2 Feb 2002, Lawrence Akka wrote:

> I have checked into cvs a first cut of an ADODB backend.  I've only
> tested this on MySql.  I still have some work to do on error handling
> etc, but it seems to work fine for me.  If you want to try it out, use
> 'dbtype' => 'ADODB' in index.php
>
> Please let me have any comments.  If you can do any benchmarks,
> that would be great.  My impression is that it is faster than PEAR, but
> that's rather unscientific.  In any event, the code needs some tightening
> anyway, so it is likely to prove faster still.
>
> It doesn't suffer from the backslash bug!
>
> Lawrence--------------------------------------------------------
> Confidentiality Notice
>
> The information contained in this e-mail is confidential.  It is for the
> use of the named recipient only.  If you are not the named recipient,
> please destroy and do not disclose the contents of this e-mail
> to any other person, or copy it.  Thank you for your co-operation.
>
>
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa