[CDBI] I feel the CLASS::DBI performance is very bad.

08:42 on 21 Nov 2005

This is a multi-part message in MIME format.

--===============1328413279==
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01EE_01C5EE4D.95BC5F50"

This is a multi-part message in MIME format.

------=_NextPart_000_01EE_01C5EE4D.95BC5F50
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

Just did some tests with CLASS::DBI,  I feel the CLASS::DBI performance =
is very bad if we use some default methods.

For example:  I used the "search" method by "XXX->search(active=3D>1)", =
I got the SQL log. =20

select usr_id from XXX where active=3D1

select username from XXX where usr_id=3Dn0
.............
select username from XXX where usr_id=3Dnn

Is this right?
------=_NextPart_000_01EE_01C5EE4D.95BC5F50
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Just did some tests with =
CLASS::DBI,&nbsp; I feel=20
the CLASS::DBI performance is very bad if we use some default=20
methods.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>For example:&nbsp; I used the "search" =
method by=20
"XXX-&gt;search(active=3D&gt;1)", I got the SQL log.&nbsp; =
<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>select usr_id from XXX where =
active=3D1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>select username from XXX where=20
usr_id=3Dn0</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>.............</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>select username from XXX where=20
usr_id=3Dnn</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is this =
right?</FONT></DIV></BODY></HTML>

------=_NextPart_000_01EE_01C5EE4D.95BC5F50--

--===============1328413279==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

--===============1328413279==--