X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 195F83A5A1B for ; Wed, 26 Jan 2005 03:47:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52174-08 for ; Wed, 26 Jan 2005 03:47:41 +0000 (GMT) Received: from out009.verizon.net (out009pub.verizon.net [206.46.170.131]) by svr1.postgresql.org (Postfix) with ESMTP id B222C3A5A01 for ; Wed, 26 Jan 2005 03:47:43 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out009.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050126034743.RXZE24088.out009.verizon.net@jfradkin> for ; Tue, 25 Jan 2005 21:47:43 -0600 From: "Joel Fradkin" To: Subject: same question little different test MSSQL vrs Postgres Date: Tue, 25 Jan 2005 22:50:51 -0500 Message-ID: <000901c5035a$3b619cc0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01C50330.528B94C0" X-Authentication-Info: Submitted using SMTP AUTH at out009.verizon.net from [66.15.127.235] at Tue, 25 Jan 2005 21:47:43 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.079 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200501/241 X-Sequence-Number: 20029 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C50330.528B94C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I also tried a simple select * from tblcase where clientum =3D 'SAKS' On both MSSQL and Postgres. MSSQL was 3 secs, Postgres was 27 secs. =20 There is a key for clientnum, but it appeared on both systems (identical Dell Desktops Postgres is running Linux MSSQL is XP) it did not do a = indexed search. =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 =20 ------=_NextPart_000_000A_01C50330.528B94C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I also tried a simple select * from tblcase where = clientum =3D ‘SAKS’

On both MSSQL and Postgres.

MSSQL was 3 secs, Postgres was 27 = secs.

 

There is a key for clientnum, but it appeared on both systems (identical Dell Desktops Postgres is running Linux MSSQL is XP) = it did not do a indexed search.

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida = 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information.  Any unauthorized = review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

 


 

 

------=_NextPart_000_000A_01C50330.528B94C0--