Accessing Postgresl from PB 6.0 - Mailing list pgsql-interfaces

From GSSC Mail
Subject Accessing Postgresl from PB 6.0
Date
Msg-id NFBBKKFPJOHBGFADCLNOAEEMCFAA.mailbox@globalscience.com.ph
Whole thread Raw
List pgsql-interfaces
<div class="Section1"><p class="MsoNormal"><span class="EmailStyle16"><font color="black" face="Times New Roman"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt; 
mso-bidi-font-family:"Times New Roman"">Please give us your feedback.</span></font></span><p class="MsoNormal"><span
class="EmailStyle16"><fontcolor="black" face="Times New Roman" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;
mso-bidi-font-family:"Times New Roman""> </span></font></span><p class="MsoNormal"
style="margin-left:.5in;text-indent:-.25in;mso-list:l0level1 lfo2; 
tab-stops:list .5in"><span class="EmailStyle16"><font color="black" face="Times New Roman" size="2"><span
style="font-size:10.0pt;
mso-bidi-font-size:12.0pt">1)<font face="Times New Roman" size="1"><span style="font:7.0pt "Times New Roman"">    
</span></font></span></font></span><spanclass="EmailStyle16"><font color="black" size="2"><span
style="font-size:10.0pt;
mso-bidi-font-size:12.0pt">We are using Power Builder 6.0 to access 200,000 records from Postrgresql 7.2.1 database in
aRed Hat 7.3 Linux and the access time is rather slow compared with accesses we made in an Oracle, Sybase, MS SQL
Serverand Access databases.</span></font></span><p class="MsoNormal"
style="margin-left:.5in;text-indent:-.25in;mso-list:l0level1 lfo2; 
tab-stops:list .5in"><span class="EmailStyle16"><font color="black" face="Times New Roman" size="2"><span
style="font-size:10.0pt;
mso-bidi-font-size:12.0pt">2)<font face="Times New Roman" size="1"><span style="font:7.0pt "Times New Roman"">    
</span></font></span></font></span><spanclass="EmailStyle16"><font color="black" size="2"><span
style="font-size:10.0pt;
mso-bidi-font-size:12.0pt">One of our machines with Power Builder hangs while accessing Postegresql with many records.
Butwe noticed that when the records are less than 5,000 the machine can again retrieve records from Postgresql. How
come?</span></font></span><pclass="MsoNormal"><span class="EmailStyle16"><font color="black" face="Times New Roman"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt; 
mso-bidi-font-family:"Times New Roman""> </span></font></span><p class="MsoNormal"><span class="EmailStyle16"><font
color="black"face="Times New Roman" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt; 
mso-bidi-font-family:"Times New Roman"">Jun G.</span></font></span><p class="MsoNormal"><span
class="EmailStyle16"><fontcolor="black" face="Times New Roman" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;
mso-bidi-font-family:"Times New Roman""> </span></font></span><p class="MsoNormal"><span class="EmailStyle16"><font
color="black"face="Times New Roman" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt; 
mso-bidi-font-family:"Times New Roman""> </span></font></span><p class="MsoNormal"><span class="EmailStyle16"><font
color="black"face="Times New Roman" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt; 
mso-bidi-font-family:"Times New Roman""> </span></font></span><p class="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;color:black"> </span></font><font color="black"><span
style="color:black;mso-color-alt:windowtext"></span></font></div>

pgsql-interfaces by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [HACKERS] ODBC problem/question
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] 7.3 gotchas for applications and client libraries