optimizations of any?
Reported by paulcc | July 28th, 2009 @ 08:30 AM
Is it worth optimising foo_equals_any [x,y,z] to "foo IN (x,y,z)"? or maybe to use regex | instead of "LIKE x OR LIKE y OR LIKE z" etc? just a thought
Comments and changes to this ticket
-
Ben Johnson July 28th, 2009 @ 04:38 PM
- State changed from “new” to “open”
To be honest, I'm not 100% sure. I'm not familiar enough with the inner working of a database to know if there would be a performance difference. My guess would be no, since they are basically the same thing, but the query would look nicer. The reason I do this is because I basically loop through the method and set the condition. If you want to fork the repo and give it a try I think it would be a worth change. But i don't think its worth complicating the code. If you can figure out a way to cleanly do it then I'm all for it.
-
paulcc July 28th, 2009 @ 08:49 PM
Quite possibly, it won't make much difference for the bigger db systems - I expect their optimizer to handle such rewrites.
We'll be using this functionality a fair bit in Spree, so I'll keep an eye on performance issues and let you know if there's a difference.
-
Ben Johnson July 30th, 2009 @ 02:42 AM
- State changed from “open” to “resolved”
Sure, I understand from a query / log perspective it doesn't look right. But the library perspective it is, it's really an issue of keeping my code DRY and simple. I'm basically just looping through a method and building the SQL, but if you find any performance issues with this please let me know and I will definitely optimize it. I just don't see that being the case, because in (X,X,X) and X or X or X are the exact same thing.
-
seomaster April 11th, 2021 @ 04:25 AM
I understand this column. I realize You put a many of struggle to found this story. I admire your process. click here
-
seomaster April 11th, 2021 @ 04:25 AM
Amazing, this is great as you want to learn more, I invite to This is my page. click here
-
seomaster April 14th, 2021 @ 06:42 AM
Cool you write, the information is very good and interesting, I'll give you a link to my site. online casino
-
seomaster April 14th, 2021 @ 06:42 AM
Beaver says I also have such interest, you can read my profile here: online casino
-
seomaster April 15th, 2021 @ 12:22 AM
Interestingly you write, I will address you'll find exciting and interesting things on similar topics. casino online canada
-
seomaster April 15th, 2021 @ 12:33 AM
It is quite beneficial, although think about the facts when it reaches this target. casino online canada
-
seomaster April 15th, 2021 @ 12:35 AM
I would recommend my profile is important to me, I invite you to discuss this topic. casino online canada
-
seomaster April 16th, 2021 @ 12:20 AM
Interestingly you write, I will address you'll find exciting and interesting things on similar topics. check here,
-
seomaster April 16th, 2021 @ 12:34 AM
It is quite beneficial, although think about the facts when it reaches this target. check here,
-
seomaster April 16th, 2021 @ 12:35 AM
I would recommend my profile is important to me, I invite you to discuss this topic. check here,
-
seomaster April 16th, 2021 @ 11:11 PM
Interestingly you write, I will address you'll find exciting and interesting things on similar topics. online casino canada real money
-
seomaster April 16th, 2021 @ 11:22 PM
It is quite beneficial, although think about the facts when it reaches this target. online casino canada real money
-
seomaster April 16th, 2021 @ 11:23 PM
I would recommend my profile is important to me, I invite you to discuss this topic. online casino canada real money
-
seomaster April 17th, 2021 @ 07:32 PM
I invite you to the page where you can read with interesting information on similar topics. Lambingan
-
seomaster April 17th, 2021 @ 07:43 PM
Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written. Lambingan
-
seomaster April 17th, 2021 @ 07:44 PM
I invite you to the page where see how much we have in common. Lambingan
-
seomaster April 18th, 2021 @ 11:19 PM
This is helpful, nonetheless it can be crucial so that you can check out the following website: kasyno online
-
seomaster April 18th, 2021 @ 11:36 PM
I encourage you to read this text it is fun described ... kasyno online
-
seomaster April 19th, 2021 @ 07:44 PM
Interestingly you write, I will address you'll find exciting and interesting things on similar topics. visit this page,
-
seomaster April 19th, 2021 @ 08:18 PM
It is quite beneficial, although think about the facts when it reaches this target. visit this page,
-
seomaster April 19th, 2021 @ 08:19 PM
I would recommend my profile is important to me, I invite you to discuss this topic. visit this page,
-
seomaster April 20th, 2021 @ 07:40 PM
Listed here you'll learn it is important, them offers the link in an helpful webpage: kasyna online
-
seomaster April 20th, 2021 @ 08:18 PM
On this page you can read my interests, write something special. kasyna online
-
seomaster April 20th, 2021 @ 08:20 PM
I encourage you to read this text it is fun described ... kasyna online
-
seomaster April 21st, 2021 @ 05:53 AM
Interestingly you write, I will address you'll find exciting and interesting things on similar topics. keno online
-
seomaster April 21st, 2021 @ 06:06 AM
It is quite beneficial, although think about the facts when it reaches this target. keno online
-
seomaster April 21st, 2021 @ 07:04 PM
I would recommend my profile is important to me, I invite you to discuss this topic. keno online
-
seomaster April 22nd, 2021 @ 11:56 PM
I just thought it may be an idea to post incase anyone else was having problems researching but I am a little unsure if I am allowed to put names and addresses on here. ranking kasyn
-
seomaster April 22nd, 2021 @ 11:57 PM
I am always searching online for storys that can accommodate me. There is obviously a multiple to understand about this. I feel you made few salubrious points in Attributes moreover. Detain busy, awesome career! ranking kasyn
-
seomaster April 24th, 2021 @ 08:21 PM
Hmm… I interpret blogs on a analogous issue, however i never visited your blog. I added it to populars also i’ll be your faithful primer. site,
-
seomaster April 24th, 2021 @ 08:34 PM
It's superior, however , check out material at the street address. learn more,
-
seomaster April 24th, 2021 @ 08:36 PM
I can recommend primarily decent and even responsible tips, as a result view it: learn more,
-
seomaster April 26th, 2021 @ 12:17 AM
Listed here you'll learn it is important, them offers the link in an helpful webpage: casino online
-
seomaster April 26th, 2021 @ 12:31 AM
On this page you can read my interests, write something special. casino online
-
seomaster April 26th, 2021 @ 12:32 AM
I encourage you to read this text it is fun described ... casino online
-
seomaster May 8th, 2021 @ 11:19 PM
Interesting and interesting information can be found on this topic here profile worth to see it. online casino uk
-
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Provides common named scopes and object based searching.
Ben Johnson
paulcc