tag:blogger.com,1999:blog-34560741.post7790671816418285216..comments2023-11-02T12:22:23.089+03:00Comments on The Momen Blog: To cache or not to cache an Oracle Sequence?Asif Momenhttp://www.blogger.com/profile/08802175768050555784noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-34560741.post-52507693075988599212009-02-21T12:14:00.000+03:002009-02-21T12:14:00.000+03:00I was shocked to discover myself that by enabling ...I was shocked to discover myself that by enabling cache on one of sequences the time dropped from 1 mins and 12 secs to 19 seconds. <BR/><BR/>I tested inserting 100,000 random records in "for loop" block.dthttps://www.blogger.com/profile/16566777921071487289noreply@blogger.comtag:blogger.com,1999:blog-34560741.post-39310535662191106622007-09-07T15:18:00.000+03:002007-09-07T15:18:00.000+03:00Hi, Great article! It really helped me. In my sequ...Hi, <BR/><BR/>Great article! <BR/><BR/>It really helped me. <BR/><BR/>In my sequence with 4928618829 values. I cached 1000 (as in your example). Execution time reduced from 1 hour to 5 minutes. :) <BR/><BR/>Just great! <BR/><BR/>Thank you.Anonymousnoreply@blogger.com