Infralution Support

[MikeR]

Using VT4 and VDO against a 64 bit PostgreSQL 9.6 server with 32 bit app and 32 bit official postgresql odbc driver installed and hooked to VDO virtual connection. Using adClient cursors. Other properties defaulted.

I am doing stress testing against VDO and VT4 for an application that requires possibly large datasets. I loaded a table with 5 million records for this test, to see what the VT would do with it.

I have a VirtualRecordset descendent composed of VirtualRecord descendents based on my database schema. The code follows the sample programs closely and appears to operate correctly in all other details.

My query is simple, SELECT * FROM MYTABLE;
The sorting is against a column that is not the primary key but another text info that can be in a different order than the primary key, and I want to keep the sort order based on that different column. If this is an issue, please let me know. I don't think it is. If I change it to match the primary key, not much different happens.

What I am finding is that the recordset loads (takes about 20 sec) and sets the Count at 84796, which is a mystery since it should be 5 million. When the tree shows rows visible, I see only the last 84793 or so records with record number 4999999 at the bottom. If I reverse the sort, I see 0000000 at the bottom and back with a total of 84792 records or so. VT uses the count apparently correctly, so I don't think VT is the bad boy here.

I am trying to figure out what is at fault, VDO, ADO, ODBC, or PostgreSQL server. Anyone have any clues or a possible workaround, please let me know. This is a show stopper for us until we get this sorted out.

Thanks.
_________________
Thanks,

-- Mike R.

[Infralution]

I think the most likely culprit here is the PostgreSQL ODBC/ADODB driver. I've just modified the Virtual Tree DatabaseBrowser sample to create over a million vehicle records. It loads these without any problems using either client or server side cursors and Virtual Tree displays them correctly.
_________________
Infralution Support

[MikeR]

Thanks, that helps. More news as it happens.
_________________
Thanks,

-- Mike R.