Received: from mail.hkcccc.org (root@[202.64.241.126]) by hub.org (8.8.8/8.7.5) with ESMTP id VAA11544 for ; Wed, 22 Apr 1998 21:34:43 -0400 (EDT) Received: from hkcccc.org ([202.64.241.101]) by mail.hkcccc.org (8.8.7/8.8.7) with ESMTP id JAA20833 for ; Thu, 23 Apr 1998 09:37:25 +0800 Message-ID: <353E9A7B.82356D1D@hkcccc.org> Date: Thu, 23 Apr 1998 09:33:47 +0800 From: Christopher Luk Organization: The Hong Kong Council of the Church of Christ in China X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-interfaces@postgreSQL.org Subject: more than 100 records Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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)