Oleg Kobchenko wrote:
I believe most database drivers are record-oriented and what we see in ODBC method SQLBindCol, which binds columns to provided arrays, is probably a helper method that iterates through the records and fills in the memory.
On the contrary, I believe most respectable sql database have this feature built-in, and sqlbindcol is just a thin layer. Only when it is not, will odbc driver do the emulation. It requires to examine the database native api for confirmation.
The logical view of sql database is record-oriented but I think that data can actually stored in inverted tables (column-wise) to maximize efficiency.
-- regards, bill ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
