psqlodbc v243 + VB + RDO - Mailing list pgsql-interfaces

From Tim Bosinius
Subject psqlodbc v243 + VB + RDO
Date
Msg-id 01BD8BD7.69385190.tim@bosinius.de
Whole thread Raw
List 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@bo.nettuno.it] mail)

David Hartwig [daveh@insightdist.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.

Regards,
Tim Bosinius








pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] Newbie needs help
Next
From: Tim Bosinius
Date:
Subject: whoops: VB RDO works just fine with new odbc driver....