Thanks walt, Non parametric queries are polluting SQL Server plan cache, which is affecting overall database performance.
I understand that parameter count for the IN clause can vary widely, but, parameterizing these queries will substantially reduce than number of generated plans. On Thursday, October 1, 2015 at 11:31:30 PM UTC-7, walt wrote: > > Fail to see the use case Faisal - plz elaborate - and keep in mind that > > Article.where id: [1,2,3,4,5,6,7,8,9,10,11, . . . , 2100] > > would generate one heck of a parameterized array ;) > > > > Den 02/10/2015 kl. 04.39 skrev Faisal Mansoor <[email protected] > <javascript:>>: > > > > Activerecord generates parameterized queries for basic types, but, it > does parameterize array types. > > > > E.g. > > > > Article.where(id: 1) > > # generates > > # SELECT "articles".* FROM "articles" WHERE "articles"."id" = $1 > [["id", 1]] > > > > But, > > > > Article.where(id: [1,2]) > > # generates > > # SELECT "articles".* FROM "articles" WHERE "articles"."id" IN (1, 2) > > # rather than > > # SELECT "articles".* FROM "articles" WHERE "articles"."id" IN ($1, $2) > > [["id", 1], ["id", 2],] > > > > Is it possible to restructure the query or use Arel to generate > parameterized query for IN clauses? > > > > > > -- > > You received this message because you are subscribed to the Google > Groups "Ruby on Rails: Talk" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/3edc1ebe-8d1b-4b42-9229-75934110b26b%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > Denne besked er blevet skannet af > > ALCO Stopspam, og menes at være fri for vira og spam. > > Klik her for at rapportere denne besked som spam. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/6ad9443b-3fd6-4e8c-b934-f8c83760ea26%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
