Page 1 of 1

ODBC enhancements ...

Posted: Wed Nov 10, 2010 10:15 am
by 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.

Re: ODBC enhancements ...

Posted: Sat Dec 11, 2010 8:40 am
by 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...