![Infralution Support Forum Index](templates/subSilver/images/logo_phpBB.gif) |
Infralution Support Support groups for Infralution products
|
View previous topic :: View next topic |
Author |
Message |
MikeR
Joined: 25 Jun 2016 Posts: 29
|
Posted: Thu Aug 17, 2017 9:30 pm Post subject: Getting around apparent recordset size limitation |
|
|
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. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Sat Aug 19, 2017 12:30 am Post subject: |
|
|
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 |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
MikeR
Joined: 25 Jun 2016 Posts: 29
|
Posted: Sat Aug 19, 2017 5:17 pm Post subject: That narrows it down |
|
|
Thanks, that helps. More news as it happens. _________________ Thanks,
-- Mike R. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|