Skip to main content
S
SpiderFromMars
Inspiring
November 24, 2009
Question

CFQUERY and blockfactor

  • November 24, 2009
  • 1 reply
  • 1752 views

Is there ever a time when blockfactor would be worthwhile adding to my CFQUERY tags?

Has anyone had positive or negative experiences with it?

Thanks,

    This topic has been closed for replies.

    1 reply

    D
    Daverms
    Inspiring
    November 24, 2009

    Hope this blog will give you some info.

    http://www.bennadel.com/blog/338-ColdFusion-CFQuery-BlockFactor-Is-Not-Impressing-Me.htm

    S
    SpiderFromMarsAuthor
    Inspiring
    November 25, 2009

    Yes, I have seen this this blog before and it is quite helpful. I have come up with the same results as he has in my MSSQL database and I was just wondering if anyone had found a way to seriously increasing performance by using blockfactor and a non-oracle database.

    Thanks for your reply!

    ilssac
    ilssac
    Inspiring
    November 25, 2009

    I suspect, mostly from that blog post, that blockfactoor is something that does not come into play until you have large record sets that exceed the 32k packet size that is the default chunk of data that is delivered to ColdFusion.

    If this is the case, then I presume, if you can set you block size to be a number of rows that will conviently fit within that packet size performace can be improved.

    This seems to require two conditions of your data, one that it be more then 32K in size and two that the rows are of a consistant size so that the number that fits in that packet can be reliable determined.

    But I have actually never bothered with this level of optimization so this is just my interpretation of the material I have read.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices