Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 07790475D84 for ; Thu, 12 Sep 2002 08:24:47 -0400 (EDT) Received: from smtp-1.mozcom.com (smtp-1.mozcom.com [202.47.132.51]) by postgresql.org (Postfix) with ESMTP id 1A137475CB1 for ; Thu, 12 Sep 2002 08:24:45 -0400 (EDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-1.mozcom.com (Postfix) with SMTP id 7A5291E8B3 for ; Thu, 12 Sep 2002 20:24:47 +0800 (PHT) Received: from junslaptop (unknown [61.9.2.38]) by smtp-1.mozcom.com (Postfix) with SMTP id C91861E773 for ; Thu, 12 Sep 2002 20:24:44 +0800 (PHT) Reply-To: From: "GSSC Mail" To: Subject: Accessing Postgresl from PB 6.0 Date: Thu, 12 Sep 2002 20:44:51 +0800 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C25A9D.3E4B9020" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Disposition-Notification-To: "GSSC Mail" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/58 X-Sequence-Number: 3119 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C25A9D.3E4B9020 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Please give us your feedback. 1) We are using Power Builder 6.0 to access 200,000 records from Postrgresql 7.2.1 database in a Red Hat 7.3 Linux and the access time is rather slow compared with accesses we made in an Oracle, Sybase, MS SQL Server and Access databases. 2) One of our machines with Power Builder hangs while accessing Postegresql with many records. But we noticed that when the records are less than 5,000 the machine can again retrieve records from Postgresql. How come? Jun G. ------=_NextPart_000_0000_01C25A9D.3E4B9020 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Please give us your feedback.<= /o:p>

 

1)     We are using Power Builder 6.0 to access 200,000 records from Postrgresql 7.2.1 database in a Red Hat 7.3 Linux and the acce= ss time is rather slow compared with accesses we made in an Oracle, Sybase, MS= SQL Server and Access databases.

2)     One of our machines with Power Builder hangs whi= le accessing Postegresql with many records. But we noticed that when the recor= ds are less than 5,000 the machine can again retrieve records from Postgresql.= How come?

 

Jun G.

 

 

 

=  

------=_NextPart_000_0000_01C25A9D.3E4B9020--