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