> have tried to focus on a few queries and what we have found > is also that the amount of data returned by SAPDB is in some > cases around 10 times that returned by MSSQL.
There are two possibilities: - you're using CHAR fields that are filled only with about 10% of real data on average. The network protocol is not very efficient because it transfers everything execpt LONGs/BLOBs as fixed char - MS SQL Server uses some compression Enhancing the network protocol is part of our log term goals. But the only immediate fix would be to use ssh tunneling. Apart from being secure, there is also an option to compress the data on the fly. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
