Re: [Phpgedview-talk] PEAR::MDB2

[Brian D. <bd...@gm...>]

Am I not seeing the developers forum or is that the "open discussion" on
sf.net?

On Jan 28, 2008 7:56 AM, John Finlay <Joh...@ne...> wrote:

>  Hi Brian,
>
>
>
> We have looked at the MDB2 library a couple of times and the results were
> posted on the developers forum.  We determined that there wasn't enough of
> an advantage to switch to MDB2.
>
>
>
> You might want to contact fisharebest to see where he left off.
>
>
>
> Here are the results from his last look at it:
>
> <snip>
>
> Just switching to MDB2 doesn't appear to make any difference to
> performance (to be expected).
>
> I'll play around with prepared statements, etc. and see if it makes a
> difference. If the driver has native support for it, then it should be
> faster. If it doesn't, it will be emulated and may well be slower.
>
>
>
> I've been experimenting with the use of prepared statements to speed our
> database access. Although it helps with performance, it (or the mysql
> driver) has a memory leak. For most pages, it isn't large enough to cause a
> problem, but importing a large gedcom causes a crash.
>
> I've tried both the latest stable and beta versions of MDB2/drivers.
>
> So, I'm not going to waste any more time on it. Maybe we can look at this
> again in the future.
>
>
>
> MDB2 - 2.5.0a1 (alpha) and 2.4.1 (stable)
> MDB2::dirver_mysql - 1.5.0a1 (alpha) and 1.4.1 (stable)
>
> Apache 2.2.3 on WinXP
>
> The test was as follows:
>
> Prepare statement
> Create array of 10 rows of data
> Loop
> Insert 10 rows using executeMultiple()
> End loop
>
>
>
>
>   ------------------------------
>
> *From:* php...@li... [mailto:
> php...@li...] *On Behalf Of *Brian Derr
> *Sent:* Sunday, January 27, 2008 11:27 PM
> *To:* All About PhpGedView
> *Subject:* [Phpgedview-talk] PEAR::MDB2
>
>
>
> Has there been any talk of upgrading the DB API to the newer MDB2 which
> has superceded PEAR::DB? I'd be willing to help out with the migration for
> 4.2 if there is interest. I didn't see it in the archives so I'm guessing
> it hasn't been talked about on here or the sf.net forums. Anyone
> interested in helping me out with it?
>
> Brian Derr
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Phpgedview-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpgedview-talk
>
>