Skip site navigation (1) Skip section navigation (2)

psqlodbc v243 + VB + RDO

From: Tim Bosinius <tim(at)bosinius(dot)de>
To: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: psqlodbc v243 + VB + RDO
Date: 1998-05-30 12:29:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I have just tested Byron's new driver with VB 5.0 and RDO.

I can use the Declare/Fetch feature with VB now and it is really quite fast when reading from
a postgres database, but I am still not able to update or insert data with VB RDO. 
The ODBC driver works with Access97 but causes the same problems (memory use on server) 
I described earlier last week and is slow ( see Jose' Soares Da Silva [sferac(at)bo(dot)nettuno(dot)it] mail)

David Hartwig [daveh(at)insightdist(dot)com] said that he needs information on the
hardware etc to compare the results - so here are some infos:

David Hartwig>  How fast is the CPU on server machine?
Server: 	Intel P120Mhz, 48MB RAM, 4GB SCSI
	RedHat Linux 5.0 (glibc-2.0.6-8), kernel 2.0.33, 64MB swap
	PostgreSQL 6.3.2, 

David Hartwig>  What are you using for a network comnnection?
client and server have SMC PCI 10/100 MBit cards and are
connected via UTP to a 10Mbit Hub. Not other machines are
on this network

David Hartwig>  How fast is the CPU on ODBC driver machine?
Client:	Intel P200Mhz, 64MB, 3,2 IDE
	M$ NT4.0w SP3, 128MB swap

David Hartwig>  What are the configuration setting on the ODBC driver?
In the driver section I use the default settings, but
I unchecked the "readonly" box.

In the datasource section I all boxes are unchecked.

David Hartwig>  Are you using unique keys?   Are they multipart keys?
For testing I did the following on all RDBMS:
-added user test with passwd test
-createdb foo
-CREATE TABLE bar (id int, name char(16));
-inserted 100 values

David Hartwig>  What kind of queries are you running?
select * from bar

David Hartwig>  Are the queries results slow?
only in Access97 

David Hartwig>  Is the rest of the system slow while running queries?
As I said - when I test the ODBC driver with VB RDO the selects
are really fast - but I cannot update or insert.
When I test with Access97 the rest of the system (client) works fine and fast,
but postgres uses about 80% CPU and 50MB mem on the server - compared to
 0.4% CPU and   3,4MB mem when I use VB RDO.
(there are other mentionable daemons running)

David Hartwig>  What are you comparing the speed to?
-mySQL is fast with Access97 but the ODBC driver does not support VB RDO
-AdabasD 6.0 - ODBC driver works with Access and VB RDO -
	(but my server is to slow for Adabas)
-Yard SQL - only tested with Access97

If the RDO stuff would work I think PostgreSQL and the InsightDist ODBC driver
is the best choice when it comes to cost/performance and I will support it
by ordering the PostgreSQL CD.

If you wish I can send you the VB RDO Test program I wrote (it is 2KB zipped).
It is only a rdc control, 2 text boxes and 10 lines of code.

Tim Bosinius

pgsql-interfaces by date

Next:From: Tim BosiniusDate: 1998-05-30 14:52:37
Subject: whoops: VB RDO works just fine with new odbc driver....
Previous:From: Mark PulverDate: 1998-05-30 04:10:06
Subject: and friends

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group