ODBC enhancements ...

[LuckyLuke]

Is it possible to add extra parameter to Databasequery command to specify the numbers of rows to be retrieved at once ?

Code: Select all

SQLSetStmtAttr(hstmt, SQL_ATTR_ROW_ARRAY_SIZE, 10, 0) 

This will get 10 records from the database at once. Improves the speed a lot (when using VPN connection).

Possible to add an Recordset 'object' ? (something similar to ADO Recordset).

Thanks.

[JustinJack]

viewtopic.php?f=5&t=43322&start=0

Go here, I put this code together to pull very large record sets, very fast, over a VPN.
you can specify the number of rows / cols everything.
I've made modifications since this posting, nothing big, i don't remember what, but. If you
have any questions about the procedures, just let me know. My life has been so easy since I've started using this
I just include "sqlSpeed.pb" and go...