RE: ODBC speed problem

From: "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com>
To: "Larry Au" <larryau(at)vinflair(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: ODBC speed problem
Date: 2001-07-17 14:17:58
Message-ID: EPEHLKLEHAHLONFOKNHNEEOMDCAA.webmaster@robbyslaughter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Larry,

I learned recently that there is a "SQL logging" feature in the ODBC control
panel which
creates a HUGE bottlneck. Might want to make sure that's turned off.

It does sound a little slow.

-Robby

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Larry Au
Sent: Thursday, July 12, 2001 1:42 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] ODBC speed problem

Dear Sir,

I am new user of Postgresql. My server OS is FreeBSD and installed
Postgres 7.1.2.
After Installed it. I import 7500 rows data into one table. Then I have
try to use Visual Basic thought ODBC to get that 7500 rows record to
Datagrid. I found that it use up around 3 mins. I would like to ask is
this a stand performance or not?

thanks

Larry.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Joseph 2001-07-17 17:58:18 Access 97, Error - Data changed by another user, Copy to Clipboard or Drop changes
Previous Message Erik Brenn 2001-07-17 08:34:46 Binary WKB data over Pgsql ODBC