tag:blogger.com,1999:blog-3309255261537841213.post1184289887249721694..comments2024-02-16T22:53:57.594+00:00Comments on IT Help and Advice: Noetix: Disabling Material Category (XXK_MTL_CAT) cachingAndy Pellewhttp://www.blogger.com/profile/10003917534384582892noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3309255261537841213.post-19126627974530179532012-04-17T08:06:41.307+01:002012-04-17T08:06:41.307+01:00Hello Andy -
Thanks for the information!
As you ha...Hello Andy -<br />Thanks for the information!<br />As you have encountered, Key flexfields data cache introduces latency. whether the latency causes a problem to a customer might vary depending upon the business need and also the key flexfield in the context.<br /><br />However, the need for the zero latency configuration option (no cache) is acknowledged by Noetix. This feature is included in the next release of Noetix Views. Please contact Noetix support for further information.<br /><br />BTW, it's a great blog it offers good insight on user's perspective especially related to Noetix views. <br /><br />Best Regards,<br />Sharas<br />NOETIXUnknownhttps://www.blogger.com/profile/02965372637041362899noreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-51237524817575847062012-04-12T09:02:06.698+01:002012-04-12T09:02:06.698+01:00I've done a quick piece of SQL;
SELECT count(...I've done a quick piece of SQL;<br /><br />SELECT count(*)<br /> FROM xxk_mtl_cat<br /><br />Which shows that we have 1760 records in total. Like I said performance does not seem to be significantly affected - at least the users aren't complaining!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-63535417700703252872012-04-07T22:10:37.878+01:002012-04-07T22:10:37.878+01:00The performance loss is, in our configuration, min...The performance loss is, in our configuration, minimal.<br /><br />Maintaining the Cache took a great deal more work and time (we operate a 24/5 reporting environment) so we couldn't just automate it.<br /><br />And not to mention that users are much happier reporting on "live" data in our environment than knowing that some things don't appear because they aren't live.<br /><br />I'll dig up the metrics on monday so I can let you know the number of items in the cache so you have a means of comparing!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3309255261537841213.post-68693283747154313642012-04-04T05:13:51.417+01:002012-04-04T05:13:51.417+01:00Hello Andy - Without Cache tables, have you observ...Hello Andy - Without Cache tables, have you observed performance degrade, for the related reports?<br /><br />Thanks,<br />SharasSharasnoreply@blogger.com