F
Frank Meulblok
Guest
As others explained, BY-REFERENCE will only work within a single instance of the AVM - either the AppServer client or the AppServer agent. Going from one to the other will always be by-value. If you're looking to gain performance in that scenario, you'll want to look into: - Schema marshalling (-ttmarshal startup parameter / SCHEMA-MARSHAL attribute of the temp-tables): cuts down the amount of metadata sent over the connection - Appserver message compression (-mc startup parameter). May or may not be worthwhile; compression/decompression algorithms have their own overhead to take into account which can nullify any benefit from sending compressed vs. uncompressed data. So benchmark before deciding when and where to use this.
Continue reading...
Continue reading...