AddQuery vs AddEncodedQuery

[Anubhav24]

Hi All,

Is there a difference between addquery and addencodedquery. Is there a performance difference between these two considering 2 scenarios : a) When only column value is being matched b)When multiple column values are being matched?

Eventually the query gets converted to "Select *" format right ?

[Mark Roethof]

Hi there,

Interesting question, never really gave it a thought if there would be a possible performance difference between the two, assuming that the end query is the same of course.

I do see some responses on this topic already, though those don't look to go into your actual question.

[Anubhav24]

Hi @Mark Roethof,

Yes I am working on one project for improving the performance and I was suggested to try and avoid EncodedQuery function , hence i wanted to understand what is the basic difference which helps to improve the performance or there is nothing like performance improvement to it ?

[Mark Roethof]

Do wonder immediately, who suggested you that? Because that person should than also be able to provide you with a proper "why"?

I usually do the opposite, using encoded queries as much as possible 🙂 Though don't know of any difference in performance in this.

[Mark Roethof]

I posted your question on SNDevs Slack, maybe someone there knows about this.

[Anubhav24]

Thank you 🙂