Tim

><< Is the local temporary table disk or memory based? >>
>
>Cached updates are always memory-based.

I was hoping you'd say that - I shall start playing with them so some of my lookup tables that rarely change.

Roy

Tim

>Yes, but those are BLOBs. Rows require that the entire row be decrypted,
>even if you're only accessing one tiny portion of it. With BLOBs, you
>normally want the entire BLOB when you read it, so the decryption penalty is
>"fair".

Well technically they are CLOBs but thank you very much for the good laugh early in the morning.

Roy