Blog Documentation Book a Demo

"Thou Shall Not Code Count Queries"

LincLinc Admin
edited December 2014 in Community Addons & Development

This appeared in the Vanilla offices this morning:

"Thou shall not code count queries - blessed are those that cache counts"

We've had a couple near-incidents lately as a result of attempting to count things via count() query. Something to beware of in your own addons! It just won't scale.

Comments

  • x00x00 MVP

    I presume you knew this already, but had some cases where you thought you might be able to get away with it.

  • peregrineperegrine MVP

    A tutorial on using the cache methods in vanilla would be useful!

  • hgtonighthgtonight MVP

    I am pretty sure I do this. I really suck a making scalable SQL it seems. :(

    Thanks for the heads up.

  • ShadowdareShadowdare MVP

    Thanks for the notice! :)

  • x00x00 MVP

    @hgtonight said:
    I am pretty sure I do this. I really suck a making scalable SQL it seems. :(

    Thanks for the heads up.

    It is not easy to do it. It is kind of the reason for no-SQL movement. It is not the query language so much as the underlying engines.

Sign In or Register to comment.