Temporary LOBs, caching and performance

[ldsandon]

How temporary LOBs cache settings impact performance (memory and speed)? I mean, what's the difference between caching them on the client or on the server?

 

[Marco Kalter]

If you cache them on the client, it will take up more client-side memory, but save network roundtrips if you read or write multiple times before passing it to the server.

If you cache them on the server, the opposite is true.