Understand Apex Cursors To Improve SOQL Performance

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 11

  • @Shri0900
    @Shri0900 5 หลายเดือนก่อน +1

    Thanks!! really helpful content...Please keep posting

  • @HimanshuSingh-ls9kz
    @HimanshuSingh-ls9kz 5 หลายเดือนก่อน +1

    Sir you are doing great it's very helpful

  • @PieterJacob
    @PieterJacob 5 หลายเดือนก่อน +1

    So, are cursors a way to avoid retrieving data sets that potentially are too large? Contact for example has the change to retrieve more than the allowed limit of records.

    • @TechnicalPotpourri
      @TechnicalPotpourri  5 หลายเดือนก่อน +1

      Not only retrieve large data sets, bur process them efficiently by breaking into small manageable chunks.

    • @PieterJacob
      @PieterJacob 5 หลายเดือนก่อน

      @@TechnicalPotpourri and how does it distinguish from a Batch? Apart from having more freedom in the chunks you are processing using a cursor…

    • @TechnicalPotpourri
      @TechnicalPotpourri  5 หลายเดือนก่อน

      @PieterJacob - A batch size in batch Apex is limited to max 2K. Lets say you can process 4K records in a transaction you would need 2 jobs. With cursors just one job is enough. The idea is if you have a process that can run quickly use cursors. You can go upwards in that scope for cursors even beyond that 2K limit that batch has

    • @PieterJacob
      @PieterJacob 5 หลายเดือนก่อน

      @@TechnicalPotpourri Thanks a lot for your answer. I will test and try it out :).
      Have a good day.

  • @awesomekj5812
    @awesomekj5812 5 หลายเดือนก่อน +1

    Is it advanced version of querylocator ?