more than 100 records - Mailing list pgsql-interfaces

From Christopher Luk
Subject more than 100 records
Date
Msg-id 353E9A7B.82356D1D@hkcccc.org
Whole thread Raw
List pgsql-interfaces
Thanks for the INSIGHT odbc drivers, its work well. However, its appear
to be quite slow. I am testing it on some table with more than 100
records (link)and with some "text" field. Server side is P166 w/ linux
2.0.30 & postgres 6.3, client side is P166MMX on chinese windows 95 w/
access 97. Duno is there any method to improve. I heard that there is a
method to increase the "cache" for the client, how can I do it?
What does slow means? I can export the linked table to access table. The
differ in speed for loading is very large. w/ access table, <10sec, w/
linked table, >2mins.......

--
Regards, Christopher Luk
   System Analyst - The Hong Kong Council of the Church of Christ in
China
              Phone : (852) 2397-1022 Fax : (852) 2397-7405
     mailto:wluk@hkcccc.org URL : http://www.hkcccc.org (Chinese based)



pgsql-interfaces by date:

Previous
From: Roman Volkoff
Date:
Subject: subscribe
Next
From: The Hermit Hacker
Date:
Subject: Re: [INTERFACES] Slowly getting there...