Accessing Postgresl from PB 6.0
От | GSSC Mail |
---|---|
Тема | Accessing Postgresl from PB 6.0 |
Дата | |
Msg-id | NFBBKKFPJOHBGFADCLNOAEEMCFAA.mailbox@globalscience.com.ph обсуждение исходный текст |
Список | 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 по дате отправления:
Следующее
От: Bruce MomjianДата:
Сообщение: Re: [HACKERS] 7.3 gotchas for applications and client libraries