I found out, that Perl's DBI-Objects have a property to specifiy the max length of longs/blobs that are fetched automatically.I think, that they are only transferred when accessed (or if the length of the content is below a certain value).Are fields containing LONG values prefetched, or only transferred when accessed?
Is there such an Optimization in SAPDB's JDBC driver too?
I didn't find an Option whichin the JDBC-API but it would be fine, that LONG columns are fetched automatically if their length is below a certain value. An extra query for each long-column rises the latency with which i get my data.
I assume, that usually the whole row is transmitted without the LONG/BLOB columns.
Another thing would be, if the protocol that JDBC uses to talk to SAPDB includes such a feature at the moment.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
