Every statement runs twice

belidzs · Post by **belidzs** » Thu 25 Mar 2010 13:39

hi,

I'm using dotConnect for PostgreSQL v4.65.62.0 with PostgreSQL 8.4.1.
My project includes a lots of tables arranged into a PgSqlDataset. Whenever I open a table using the PgSqlDataTable.Open() statement, it runs the select statement twice. I've double checked this checking the dbMonitor software and the server's log file.
Also a strange behaviour, if I set a datatable's MaxRecords, it downloads all the records first, then runs the same statement with the "limit" keyword. (check the log below)

Please fix this, cause using less bandwidth is an important aspect at my client (they sometimes use the software through VPN, which has only 5 kb/s bandwidth)

Thanks,
Balazs

Code: Select all

2010-03-25 14:34:39 CET LOG:  execute PRSTMT1520887791493473796/PORTAL1520887791493473796: select * from projektek_sajat_foablak
2010-03-25 14:34:39 CET LOG:  execute PRSTMT9497010861493474093/PORTAL9497010861493474093: SELECT a.attname as fieldname, a.attnum  as fieldordinal, a.atttyp
2010-03-25 14:34:39 CET LOG:  execute PRSTMT1521909191493474109/PORTAL1521909191493474109: select * from projektek_sajat_foablak
2010-03-25 14:34:39 CET LOG:  execute PRSTMT8493175201493474140/PORTAL8493175201493474140: SELECT * FROM esemenyek_sajat_foablak ORDER BY letrehozva DESC
2010-03-25 14:34:39 CET LOG:  execute PRSTMT15669818651493474218/PORTAL15669818651493474218: SELECT a.attname as fieldname, a.attnum  as fieldordinal, a.attt
2010-03-25 14:34:39 CET LOG:  execute PRSTMT16749773721493474234/PORTAL16749773721493474234: SELECT * FROM esemenyek_sajat_foablak ORDER BY letrehozva DESC
         LIMIT 300
2010-03-25 14:34:39 CET LOG:  execute PRSTMT15575852611493474265/PORTAL15575852611493474265: SELECT a.attname as fieldname, a.attnum  as fieldordinal, a.attt

StanislavK · Post by **StanislavK** » Fri 26 Mar 2010 14:03

We have reproduced both problems. We will investigate them and notify you about the results.

belidzs · Post by **belidzs** » Wed 21 Apr 2010 20:42

StanislavK wrote:We have reproduced both problems. We will investigate them and notify you about the results.

Is there any progress about this?

StanislavK · Post by **StanislavK** » Thu 22 Apr 2010 08:33

We have fixed the issue, the fix will be available in one of the nearest builds. We will inform you when the corresponding build is released.

StanislavK · Post by **StanislavK** » Fri 21 May 2010 16:54

We have released the new 4.95.140 build of dotConnect for PostgreSQL. It can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

In the new build, executing of redundant queries was removed from PgSqlDataTable.Open(). For more information on fixes and improvements available in version 4.95.140, please see
http://www.devart.com/forums/viewtopic.php?t=18032