Unnecessary "direct path write temp" with passing clob as parameter.

Issue #11 closed
Dronablo
created an issue

Hi there!

In LobVar.c, LobVar_SetValue we call OCILobCreateTemporary with parameter cache set to false. It leads to the at least single "direct path write temp" call, which in turn leads to physical IO. So, for example, if I want to write 500 clobs per second with just a single char, I consume 500 IOPS at the server. Can you change cache to true, or, at least make it optional?

Thank you!

Regards, Andrey

Comments (1)

  1. Log in to comment