However, in this specific case I cannot. The reason is that I made some test with measuring the times for the amount of time that is needed to transmit data from a server to the client by ODBC. To be honest - I didn't compare this ODBC speed with other DB's, I only bulit my simple DCOM server component (with VB) which was trasmitting all the data from SAP DB to the client.
Basically, you're right. The network protocol doesn't know about VARCHARS, so results are always transfered with maximum length.
This costs almost nothing in the local case (shared memory), something in the LAN case and a lot in the modem/WAN case I mentioned.
LONGs/Blobs are not affected by this, they are transferred efficiently.
It is not the fault of the ODBC driver. The network protocol itself has this flaw, so all clients suffer from it.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
