Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA19507
	for <pgsql-interfaces@postgresql.org>;
	Fri, 11 Feb 2000 11:09:23 -0500 (EST)
	(envelope-from jose@sferacarta.com)
Received: from proxy.sferacarta.com (sfcabop1.nettuno.it [193.207.10.213])
	by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 4.1) with ESMTP id RAA05180;
	Fri, 11 Feb 2000 17:08:50 +0100 (MET)
Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5]
	by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian))
	id 12JHBW-0001om-00; Fri, 11 Feb 2000 14:36:38 +0000
Message-ID: <38A41154.6CC13454@sferacarta.com>
Date: Fri, 11 Feb 2000 14:40:36 +0100
From: Jose Soares <jose@sferacarta.com>
Organization: Sfera Carta
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Chandra Wibawa <chandraw@prima.net.id>,
	interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Thank for your Clue - PostgreSQL ODBC
References: <001001bf7301$5dec6c00$230039ca@prima.net.id>
	<38A16AE9.A95E79BF@sferacarta.com>
	<000d01bf748c$b02c4d00$230039ca@prima.net.id>
Content-Type: multipart/alternative;
	boundary="------------F42F1F8D7ED9319C920C1DCB"


--------------F42F1F8D7ED9319C920C1DCB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Chandra Wibawa wrote:

>  Dear Jose, Our server configuration is :1. Pentium III 500, 256 MB,
> SCSI U2W2. SuSE 6.2, PostgreSQL 6.5.3 Our client configuration is :1.
> Pentium 133, RAM 40 MB, IDE2. Windows 98, Access 973. ODBC From
> Insight
> What version of PsqlODBC are you running? You need 6.40.0007.
> I remember this behavior the first times we started using
> access->PostgreSQL but now I don't remember
> why.
> Send this mail to interfaces@postgresql.org, there is Byron Nikolaidis
> the author of the ODBC driver, he
> certanly knows this behavior.
> Also take a look at the FAQ:
> http://www.insightdist.com/psqlodbc/psqlodbc_faq.html
>
>  Our network is :1. Network Hub 10 Mb I have followed your hints, it
> does improve the performance. 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 scrolled down the MS Access windowit took a
> very long time to scroll down (5 minutes). When i tried to scroll to
> the last record, i had to waitfor ages, and finally when i pressed
> Ctrl-Alt-Del, i saw  a message "not responding" on MS Access. Could
> you tell me what could be done to overcome this problem ? Could this
> be the network, or the client ? Thanks for your help. Regards,Chandra
>
>      ----- Original Message -----
>      From: jose
>      To: Chandra Wibawa
>      Sent: Wednesday, February 09, 2000 20:26
>      Subject: Re: Thank for your Clue - PostgreSQL ODBC
>
>
>      Chandra Wibawa ha scritto:
>
>     > Thank's Jose, I have succesfully connected my database
>     > (postgreSQL) to Access 97 on client machine. But I think
>     > there is still big problem because the link table takes
>     > takes too much time (maybe around 45 - 60 minutes, even
>     > not responding).Would you mind give me suggestion to solve
>     > my problem ? For your information, our configuration :1.
>     > Processor 133 MHz at client side2. Harddisk 1 GB at client
>     > side3. RAM 40 MB at client side4. Our LAN speed is 10 Mbps
>
>      Is this your server or client ?
>
>      M$ access is very slow but 45-60 minutes is too much
>      This seems like a net problem.
>      Anyway try to tune ODBC drive.
>
>      GO TO Options(Advanced)
>      Driver:
>
>      check on:
>      <KSQO>
>      <Recognize unique indexes>
>      <Use declare/fetch>
>
>      check off:
>
>      <CommLog>
>      <Parse statments>
>
>      DataSource:
>
>      check on.
>      <Row versioning>
>
>
>      I hope this help you.
>
>      Jose'
>
>
--
Jose' Soares
Bologna, Italy                     Jose@sferacarta.com


--------------F42F1F8D7ED9319C920C1DCB
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
&nbsp;
<p>Chandra Wibawa wrote:
<blockquote TYPE=CITE>&nbsp;Dear Jose,&nbsp;Our server configuration is
:1. Pentium III 500, 256 MB, SCSI U2W2. SuSE 6.2, PostgreSQL 6.5.3&nbsp;<font face="Arial"><font size=-1>Our
client configuration is :</font></font><font face="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>&nbsp;
<br>What version of PsqlODBC are you running? You need 6.40.0007.
<br>I remember this behavior the first times we started using 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:&nbsp; <A HREF="http://www.insightdist.com/psqlodbc/psqlodbc_faq.html">http://www.insightdist.com/psqlodbc/psqlodbc_faq.html</A>
<br>&nbsp;
<br>&nbsp;<font face="Arial"><font size=-1>Our network is :</font></font>1.
Network Hub 10 Mb&nbsp;<font face="Arial"><font size=-1>I have followed
your hints, it does improve the performance.</font></font>&nbsp;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 scrolled down the
MS Access windowit took a very long time to scroll down (5 minutes). When
i tried to scroll to the last record, i had to waitfor ages, and finally
when i pressed Ctrl-Alt-Del, i saw&nbsp; a message "not responding" on
MS Access.&nbsp;<font face="Arial"><font size=-1>Could you tell me what
could be done to overcome this problem ?</font></font>&nbsp;<font face="Arial"><font size=-1>Could
this be the network, or the client ?</font></font>&nbsp;<font face="Arial"><font size=-1>Thanks
for your help.</font></font>&nbsp;<font face="Arial"><font size=-1>Regards,</font></font><font face="Arial"><font size=-1>Chandra</font></font>
<blockquote 
style="BORDER-LEFT: #000000 2px 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: 10pt arial"><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>
&nbsp;
<p>Chandra Wibawa ha scritto:
<blockquote TYPE="CITE"><style></style>
<font face="Arial"><font size=-1>Thank's
Jose,</font></font> <font face="Arial"><font size=-1>I have succesfully
connected my database (postgreSQL) to Access 97 on client machine. But
I think there is still big problem because the link table takes takes too
much time (maybe around 45 - 60 minutes, even not responding).Would you
mind give me suggestion to solve my problem ?</font></font> <font face="Arial"><font size=-1>For
your information, our configuration :1. Processor 133 MHz at client side2.
Harddisk 1 GB at client side3. RAM 40 MB at client side4. Our LAN speed
is 10 Mbps</font></font></blockquote>
Is this your server or client ?
<p>M$ access is very slow but 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>&lt;KSQO>
<br>&lt;Recognize unique indexes>
<br>&lt;Use declare/fetch>
<p>check off:
<p>&lt;CommLog>
<br>&lt;Parse statments>
<p>DataSource:
<p>check on.
<br>&lt;Row versioning>
<br>&nbsp;
<p>I hope this help you.
<p>Jose'
<br>&nbsp;</blockquote>
</blockquote>

<p>--
<br>Jose' Soares
<br>Bologna, Italy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Jose@sferacarta.com
<br>&nbsp;
</body>
</html>

--------------F42F1F8D7ED9319C920C1DCB--