JDB_AddTableToDBCache

[Ramprakash]

Hi,

I have used JDB_AddTableToDBCache API to include a table in Cache using a UBE. I want to know whether system will add the table in cache everytime when i call the report? Also how this will increase the performance when I use do more fetches on table?

 

[OWDev]

Hi,

Adding elements to cache will ultimately chew up more and more memory. The API you used will add a table to cache. There is also an API to remove the table from cache. You should use this api at the end of whatever processing you do and ultimately terminating the cache as part of your cleanup.

Off course if your system is rebooted on a regular basis you will not see any performance degradation as all memory will be freed.

Hope the above helps.

 

[sajadhav_pw]

Hi,
I have create a Business Function & used to Api JDB_AddTableToDBCache. Every time i run it it gives a warning in log.
JDB3800028 - Warning... the application is not allowed to perform this action. The F4101 table will not be cached.