phpgedview-talk

[Phpgedview-talk] PEAR::MDB2

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

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.2if 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

Re: [Phpgedview-talk] PEAR::MDB2

[John F. <Joh...@ne...>]

SGkgQnJpYW4sDQoNCiANCg0KV2UgaGF2ZSBsb29rZWQgYXQgdGhlIE1EQjIgbGlicmFyeSBhIGNv
dXBsZSBvZiB0aW1lcyBhbmQgdGhlIHJlc3VsdHMgd2VyZSBwb3N0ZWQgb24gdGhlIGRldmVsb3Bl
cnMgZm9ydW0uICBXZSBkZXRlcm1pbmVkIHRoYXQgdGhlcmUgd2FzbuKAmXQgZW5vdWdoIG9mIGFu
IGFkdmFudGFnZSB0byBzd2l0Y2ggdG8gTURCMi4NCg0KIA0KDQpZb3UgbWlnaHQgd2FudCB0byBj
b250YWN0IGZpc2hhcmViZXN0IHRvIHNlZSB3aGVyZSBoZSBsZWZ0IG9mZi4NCg0KIA0KDQpIZXJl
IGFyZSB0aGUgcmVzdWx0cyBmcm9tIGhpcyBsYXN0IGxvb2sgYXQgaXQ6DQoNCjxzbmlwPg0KDQpK
dXN0IHN3aXRjaGluZyB0byBNREIyIGRvZXNuJ3QgYXBwZWFyIHRvIG1ha2UgYW55IGRpZmZlcmVu
Y2UgdG8gcGVyZm9ybWFuY2UgKHRvIGJlIGV4cGVjdGVkKS4gDQogDQpJJ2xsIHBsYXkgYXJvdW5k
IHdpdGggcHJlcGFyZWQgc3RhdGVtZW50cywgZXRjLiBhbmQgc2VlIGlmIGl0IG1ha2VzIGEgZGlm
ZmVyZW5jZS4gSWYgdGhlIGRyaXZlciBoYXMgbmF0aXZlIHN1cHBvcnQgZm9yIGl0LCB0aGVuIGl0
IHNob3VsZCBiZSBmYXN0ZXIuIElmIGl0IGRvZXNuJ3QsIGl0IHdpbGwgYmUgZW11bGF0ZWQgYW5k
IG1heSB3ZWxsIGJlIHNsb3dlci4NCg0KIA0KDQpJJ3ZlIGJlZW4gZXhwZXJpbWVudGluZyB3aXRo
IHRoZSB1c2Ugb2YgcHJlcGFyZWQgc3RhdGVtZW50cyB0byBzcGVlZCBvdXIgZGF0YWJhc2UgYWNj
ZXNzLiBBbHRob3VnaCBpdCBoZWxwcyB3aXRoIHBlcmZvcm1hbmNlLCBpdCAob3IgdGhlIG15c3Fs
IGRyaXZlcikgaGFzIGEgbWVtb3J5IGxlYWsuIEZvciBtb3N0IHBhZ2VzLCBpdCBpc24ndCBsYXJn
ZSBlbm91Z2ggdG8gY2F1c2UgYSBwcm9ibGVtLCBidXQgaW1wb3J0aW5nIGEgbGFyZ2UgZ2VkY29t
IGNhdXNlcyBhIGNyYXNoLiANCiANCkkndmUgdHJpZWQgYm90aCB0aGUgbGF0ZXN0IHN0YWJsZSBh
bmQgYmV0YSB2ZXJzaW9ucyBvZiBNREIyL2RyaXZlcnMuIA0KIA0KU28sIEknbSBub3QgZ29pbmcg
dG8gd2FzdGUgYW55IG1vcmUgdGltZSBvbiBpdC4gTWF5YmUgd2UgY2FuIGxvb2sgYXQgdGhpcyBh
Z2FpbiBpbiB0aGUgZnV0dXJlLg0KDQogDQoNCk1EQjIgLSAyLjUuMGExIChhbHBoYSkgYW5kIDIu
NC4xIChzdGFibGUpICANCk1EQjI6OmRpcnZlcl9teXNxbCAtIDEuNS4wYTEgKGFscGhhKSBhbmQg
MS40LjEgKHN0YWJsZSkgDQogDQpBcGFjaGUgMi4yLjMgb24gV2luWFAgDQogDQpUaGUgdGVzdCB3
YXMgYXMgZm9sbG93czogDQogDQpQcmVwYXJlIHN0YXRlbWVudCANCkNyZWF0ZSBhcnJheSBvZiAx
MCByb3dzIG9mIGRhdGEgDQpMb29wIA0KSW5zZXJ0IDEwIHJvd3MgdXNpbmcgZXhlY3V0ZU11bHRp
cGxlKCkgDQpFbmQgbG9vcA0KDQogDQoNCiANCg0KX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX18NCg0KRnJvbTogcGhwZ2Vkdmlldy10YWxrLWJvdW5jZXNAbGlzdHMuc291cmNlZm9yZ2Uu
bmV0IFttYWlsdG86cGhwZ2Vkdmlldy10YWxrLWJvdW5jZXNAbGlzdHMuc291cmNlZm9yZ2UubmV0
XSBPbiBCZWhhbGYgT2YgQnJpYW4gRGVycg0KU2VudDogU3VuZGF5LCBKYW51YXJ5IDI3LCAyMDA4
IDExOjI3IFBNDQpUbzogQWxsIEFib3V0IFBocEdlZFZpZXcNClN1YmplY3Q6IFtQaHBnZWR2aWV3
LXRhbGtdIFBFQVI6Ok1EQjINCg0KIA0KDQpIYXMgdGhlcmUgYmVlbiBhbnkgdGFsayBvZiB1cGdy
YWRpbmcgdGhlIERCIEFQSSB0byB0aGUgbmV3ZXIgTURCMiB3aGljaCBoYXMgc3VwZXJjZWRlZCBQ
RUFSOjpEQj8gSSdkIGJlIHdpbGxpbmcgdG8gaGVscCBvdXQgd2l0aCB0aGUgbWlncmF0aW9uIGZv
ciA0LjIgaWYgdGhlcmUgaXMgaW50ZXJlc3QuIEkgZGlkbid0IHNlZSBpdCBpbiB0aGUgYXJjaGl2
ZXMgc28gSSdtIGd1ZXNzaW5nIGl0IGhhc24ndCBiZWVuIHRhbGtlZCBhYm91dCBvbiBoZXJlIG9y
IHRoZSBzZi5uZXQgZm9ydW1zLiBBbnlvbmUgaW50ZXJlc3RlZCBpbiBoZWxwaW5nIG1lIG91dCB3
aXRoIGl0Pw0KDQpCcmlhbiBEZXJyDQoNCg==

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
>
>

Re: [Phpgedview-talk] PEAR::MDB2

[John F. <Joh...@ne...>]

U29ycnksIHRoZSBkZXZlbG9wZXJzIGZvcnVtIGlzIG9ubHkgYWNjZXNzaWJsZSB0byBwZW9wbGUg
b24gdGhlIHByb2plY3QgdGVhbS4gIFRoYXQgaXMgd2h5IGluY2x1ZGVkIHBhcnQgb2YgdGhlIGRp
c2N1c3Npb24gdGhyZWFkIGluIHRoZSBwcmV2aW91cyBlbWFpbC4NCg0KIA0KDQpZb3UgYXJlIHdl
bGNvbWUgdG8gYnJpbmcgaXQgdXAgYWdhaW4gaW4gb25lIG9mIHRoZSBvdGhlciBmb3J1bXMuDQoN
CiANCg0KVGhhbmtzLA0KDQotLUpvaG4NCg0KIA0KDQogDQoNCl9fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fDQoNCkZyb206IHBocGdlZHZpZXctdGFsay1ib3VuY2VzQGxpc3RzLnNvdXJj
ZWZvcmdlLm5ldCBbbWFpbHRvOnBocGdlZHZpZXctdGFsay1ib3VuY2VzQGxpc3RzLnNvdXJjZWZv
cmdlLm5ldF0gT24gQmVoYWxmIE9mIEJyaWFuIERlcnINClNlbnQ6IFR1ZXNkYXksIEphbnVhcnkg
MjksIDIwMDggOToxNiBQTQ0KVG86IEFsbCBBYm91dCBQaHBHZWRWaWV3DQpTdWJqZWN0OiBSZTog
W1BocGdlZHZpZXctdGFsa10gUEVBUjo6TURCMg0KDQogDQoNCkFtIEkgbm90IHNlZWluZyB0aGUg
ZGV2ZWxvcGVycyBmb3J1bSBvciBpcyB0aGF0IHRoZSAib3BlbiBkaXNjdXNzaW9uIiBvbiBzZi5u
ZXQ/DQoNCk9uIEphbiAyOCwgMjAwOCA3OjU2IEFNLCBKb2huIEZpbmxheSA8Sm9obi5GaW5sYXlA
bmV1bW9udC5lZHU+IHdyb3RlOg0KDQpIaSBCcmlhbiwNCg0KIA0KDQpXZSBoYXZlIGxvb2tlZCBh
dCB0aGUgTURCMiBsaWJyYXJ5IGEgY291cGxlIG9mIHRpbWVzIGFuZCB0aGUgcmVzdWx0cyB3ZXJl
IHBvc3RlZCBvbiB0aGUgZGV2ZWxvcGVycyBmb3J1bS4gIFdlIGRldGVybWluZWQgdGhhdCB0aGVy
ZSB3YXNuJ3QgZW5vdWdoIG9mIGFuIGFkdmFudGFnZSB0byBzd2l0Y2ggdG8gTURCMi4NCg0KIA0K
DQpZb3UgbWlnaHQgd2FudCB0byBjb250YWN0IGZpc2hhcmViZXN0IHRvIHNlZSB3aGVyZSBoZSBs
ZWZ0IG9mZi4NCg0KIA0KDQpIZXJlIGFyZSB0aGUgcmVzdWx0cyBmcm9tIGhpcyBsYXN0IGxvb2sg
YXQgaXQ6DQoNCjxzbmlwPg0KDQpKdXN0IHN3aXRjaGluZyB0byBNREIyIGRvZXNuJ3QgYXBwZWFy
IHRvIG1ha2UgYW55IGRpZmZlcmVuY2UgdG8gcGVyZm9ybWFuY2UgKHRvIGJlIGV4cGVjdGVkKS4g
DQogDQpJJ2xsIHBsYXkgYXJvdW5kIHdpdGggcHJlcGFyZWQgc3RhdGVtZW50cywgZXRjLiBhbmQg
c2VlIGlmIGl0IG1ha2VzIGEgZGlmZmVyZW5jZS4gSWYgdGhlIGRyaXZlciBoYXMgbmF0aXZlIHN1
cHBvcnQgZm9yIGl0LCB0aGVuIGl0IHNob3VsZCBiZSBmYXN0ZXIuIElmIGl0IGRvZXNuJ3QsIGl0
IHdpbGwgYmUgZW11bGF0ZWQgYW5kIG1heSB3ZWxsIGJlIHNsb3dlci4NCg0KIA0KDQpJJ3ZlIGJl
ZW4gZXhwZXJpbWVudGluZyB3aXRoIHRoZSB1c2Ugb2YgcHJlcGFyZWQgc3RhdGVtZW50cyB0byBz
cGVlZCBvdXIgZGF0YWJhc2UgYWNjZXNzLiBBbHRob3VnaCBpdCBoZWxwcyB3aXRoIHBlcmZvcm1h
bmNlLCBpdCAob3IgdGhlIG15c3FsIGRyaXZlcikgaGFzIGEgbWVtb3J5IGxlYWsuIEZvciBtb3N0
IHBhZ2VzLCBpdCBpc24ndCBsYXJnZSBlbm91Z2ggdG8gY2F1c2UgYSBwcm9ibGVtLCBidXQgaW1w
b3J0aW5nIGEgbGFyZ2UgZ2VkY29tIGNhdXNlcyBhIGNyYXNoLiANCiANCkkndmUgdHJpZWQgYm90
aCB0aGUgbGF0ZXN0IHN0YWJsZSBhbmQgYmV0YSB2ZXJzaW9ucyBvZiBNREIyL2RyaXZlcnMuIA0K
IA0KU28sIEknbSBub3QgZ29pbmcgdG8gd2FzdGUgYW55IG1vcmUgdGltZSBvbiBpdC4gTWF5YmUg
d2UgY2FuIGxvb2sgYXQgdGhpcyBhZ2FpbiBpbiB0aGUgZnV0dXJlLg0KDQogDQoNCk1EQjIgLSAy
LjUuMGExIChhbHBoYSkgYW5kIDIuNC4xIChzdGFibGUpICANCk1EQjI6OmRpcnZlcl9teXNxbCAt
IDEuNS4wYTEgKGFscGhhKSBhbmQgMS40LjEgKHN0YWJsZSkgDQogDQpBcGFjaGUgMi4yLjMgb24g
V2luWFAgDQogDQpUaGUgdGVzdCB3YXMgYXMgZm9sbG93czogDQogDQpQcmVwYXJlIHN0YXRlbWVu
dCANCkNyZWF0ZSBhcnJheSBvZiAxMCByb3dzIG9mIGRhdGEgDQpMb29wIA0KSW5zZXJ0IDEwIHJv
d3MgdXNpbmcgZXhlY3V0ZU11bHRpcGxlKCkgDQpFbmQgbG9vcA0KDQogDQoNCiANCg0KX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX18NCg0KRnJvbTogcGhwZ2Vkdmlldy10YWxrLWJvdW5j
ZXNAbGlzdHMuc291cmNlZm9yZ2UubmV0IFttYWlsdG86cGhwZ2Vkdmlldy10YWxrLWJvdW5jZXNA
bGlzdHMuc291cmNlZm9yZ2UubmV0XSBPbiBCZWhhbGYgT2YgQnJpYW4gRGVycg0KU2VudDogU3Vu
ZGF5LCBKYW51YXJ5IDI3LCAyMDA4IDExOjI3IFBNDQpUbzogQWxsIEFib3V0IFBocEdlZFZpZXcN
ClN1YmplY3Q6IFtQaHBnZWR2aWV3LXRhbGtdIFBFQVI6Ok1EQjINCg0KIA0KDQpIYXMgdGhlcmUg
YmVlbiBhbnkgdGFsayBvZiB1cGdyYWRpbmcgdGhlIERCIEFQSSB0byB0aGUgbmV3ZXIgTURCMiB3
aGljaCBoYXMgc3VwZXJjZWRlZCBQRUFSOjpEQj8gSSdkIGJlIHdpbGxpbmcgdG8gaGVscCBvdXQg
d2l0aCB0aGUgbWlncmF0aW9uIGZvciA0LjIgaWYgdGhlcmUgaXMgaW50ZXJlc3QuIEkgZGlkbid0
IHNlZSBpdCBpbiB0aGUgYXJjaGl2ZXMgc28gSSdtIGd1ZXNzaW5nIGl0IGhhc24ndCBiZWVuIHRh
bGtlZCBhYm91dCBvbiBoZXJlIG9yIHRoZSBzZi5uZXQgZm9ydW1zLiBBbnlvbmUgaW50ZXJlc3Rl
ZCBpbiBoZWxwaW5nIG1lIG91dCB3aXRoIGl0Pw0KDQpCcmlhbiBEZXJyDQoNCg0KLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQ0KVGhpcyBTRi5uZXQgZW1haWwgaXMgc3BvbnNvcmVkIGJ5OiBNaWNyb3NvZnQNCkRl
ZnkgYWxsIGNoYWxsZW5nZXMuIE1pY3Jvc29mdChSKSBWaXN1YWwgU3R1ZGlvIDIwMDguDQpodHRw
Oi8vY2xrLmF0ZG10LmNvbS9NUlQvZ28vdnNlMDEyMDAwMDA3MG1ydC9kaXJlY3QvMDEvDQpfX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KUGhwZ2Vkdmlldy10
YWxrIG1haWxpbmcgbGlzdA0KUGhwZ2Vkdmlldy10YWxrQGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0K
aHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vcGhwZ2Vkdmlldy10
YWxrDQoNCiANCg0K