Thread: VB slow access

Hi:

I am writting a Visual Basic 4.0 app. I use PostgreSQL 7.1.3 on a Linux Mandrake 8.1 Server.  Connection is through
ODBC(v. 7.0.8). The database has 35 tables, the biggest with 35.000 records.  

My problem is when I write in the database (I write to 10 tables in the db). It takes about 25 seconds to complete the
writtingoperation, wich is a lot of time. It takes only a second to do the same for the pgadmin using the same ODBC and
computers.

Can you help me?

Thanks in advance,
Lucas


Find the best deals on the web at AltaVista Shopping!
http://www.shopping.altavista.com

> -----Original Message-----
> From: Lucas Grijander [mailto:cuidadin@altavista.com]
> Sent: 10 December 2001 14:24
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] VB slow access
>
>
> Hi:
>
> I am writting a Visual Basic 4.0 app. I use PostgreSQL 7.1.3
> on a Linux Mandrake 8.1 Server.  Connection is through ODBC
> (v. 7.0.8). The database has 35 tables, the biggest with
> 35.000 records.
>
> My problem is when I write in the database (I write to 10
> tables in the db). It takes about 25 seconds to complete the
> writting operation, wich is a lot of time. It takes only a
> second to do the same for the pgadmin using the same ODBC and
> computers.

Hi,

Do you have all the logging switched off? pgAdmin II doesn't use DSN's so if
the DSN you are using from your VB app has logging enabled, then that may be
the cause of the speed problem.

If this isn't the problem, perhaps you could provide some examples of the
code you are using.

Regards, Dave.