Re: Thank for your Clue - PostgreSQL ODBC - Mailing list pgsql-interfaces
From | Jose Soares |
---|---|
Subject | Re: Thank for your Clue - PostgreSQL ODBC |
Date | |
Msg-id | 38A41154.6CC13454@sferacarta.com Whole thread Raw |
List | pgsql-interfaces |
<p>Chandra Wibawa wrote: <blockquote type="CITE"> Dear Jose, Our server configuration is :1. Pentium III 500, 256 MB,SCSI U2W2. SuSE 6.2, PostgreSQL 6.5.3 <font face="Arial"><font size="-1">Our client configuration is :</font></font><fontface="Arial"><font size="-1">1. Pentium 133, RAM 40 MB, IDE</font></font><font face="Arial"><font size="-1">2.Windows 98, Access 97</font></font><font face="Arial"><font size="-1">3. ODBC From Insight</font></font> <br/>What version of PsqlODBC are you running? You need 6.40.0007. <br />I remember this behavior the first times we startedusing access->PostgreSQL but now I don't remember <br />why. <br />Send this mail to interfaces@postgresql.org,there is Byron Nikolaidis the author of the ODBC driver, he <br />certanly knows this behavior.<br />Also take a look at the FAQ: <a href="http://www.insightdist.com/psqlodbc/psqlodbc_faq.html">http://www.insightdist.com/psqlodbc/psqlodbc_faq.html</a><br /> <br /> <font face="Arial"><font size="-1">Our network is :</font></font>1. Network Hub 10 Mb <font face="Arial"><fontsize="-1">I have followed your hints, it does improve the performance.</font></font> I have done some testings,retrieving 3000 records from server to client.I can see the first hundred lines of the record, but when i scrolleddown the MS Access windowit took a very long time to scroll down (5 minutes). When i tried to scroll to the lastrecord, i had to waitfor ages, and finally when i pressed Ctrl-Alt-Del, i saw a message "not responding" on MS Access. <fontface="Arial"><font size="-1">Could you tell me what could be done to overcome this problem ?</font></font> <fontface="Arial"><font size="-1">Could this be the network, or the client ?</font></font> <font face="Arial"><fontsize="-1">Thanks for your help.</font></font> <font face="Arial"><font size="-1">Regards,</font></font><fontface="Arial"><font size="-1">Chandra</font></font><blockquote style="BORDER-LEFT: #0000002px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"><div style="FONT: 10pt arial">-----Original Message -----</div><div style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><b>From:</b><a href="mailto:jose@sferacarta.com" title="jose@sferacarta.com">jose</a></div><div style="FONT: 10ptarial"><b>To:</b> <a href="mailto:chandraw@prima.net.id" title="chandraw@prima.net.id">Chandra Wibawa</a></div><div style="FONT:10pt arial"><b>Sent:</b> Wednesday, February 09, 2000 20:26</div><div style="FONT: 10pt arial"><b>Subject:</b>Re: Thank for your Clue - PostgreSQL ODBC</div> <p>Chandra Wibawa ha scritto: <blockquote type="CITE"><style></style><fontface="Arial"><font size="-1">Thank's Jose,</font></font> <font face="Arial"><font size="-1">Ihave succesfully connected my database (postgreSQL) to Access 97 on client machine. But I think there is stillbig problem because the link table takes takes too much time (maybe around 45 - 60 minutes, even not responding).Wouldyou mind give me suggestion to solve my problem ?</font></font> <font face="Arial"><font size="-1">For yourinformation, our configuration :1. Processor 133 MHz at client side2. Harddisk 1 GB at client side3. RAM 40 MB at clientside4. Our LAN speed is 10 Mbps</font></font></blockquote> Is this your server or client ? <p>M$ access is very slowbut 45-60 minutes is too much <br />This seems like a net problem. <br />Anyway try to tune ODBC drive. <p>GO TO Options(Advanced)<br />Driver: <p>check on: <br /><KSQO> <br /><Recognize unique indexes> <br /><Use declare/fetch><p>check off: <p><CommLog> <br /><Parse statments> <p>DataSource: <p>check on. <br /><Rowversioning> <br /> <p>I hope this help you. <p>Jose' <br /> </blockquote></blockquote><p>-- <br />Jose' Soares<br />Bologna, Italy Jose@sferacarta.com <br />
pgsql-interfaces by date: