473,395 Members | 1,689 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Performance impact of using of like vs excluding

63
Do you know how much of a performance impact using the LIKE "*" statement would make, versus just excluding that criteria if the "ALL" option is selected? Just curious.

Thanks.
Jun 9 '11 #1

✓ answered by NeoPa

I guess that would depend on the data you had to process, but I can't say how much of a hit it would take.

Certainly in most cases it wouldn't be noticeable. How many thousands of records you'd need to have even to see a difference I don't know. Whether it would make a difference even then is hard to know. It's possible the SQL engine would optimise it away anyway, thus leaving the filter exactly as if that part weren't included.

I would recommend you start to worry about that only if you ever notice any difference yourself.

1 1390
NeoPa
32,556 Expert Mod 16PB
I guess that would depend on the data you had to process, but I can't say how much of a hit it would take.

Certainly in most cases it wouldn't be noticeable. How many thousands of records you'd need to have even to see a difference I don't know. Whether it would make a difference even then is hard to know. It's possible the SQL engine would optimise it away anyway, thus leaving the filter exactly as if that part weren't included.

I would recommend you start to worry about that only if you ever notice any difference yourself.
Jun 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Andrew James | last post by:
Hi, I've been looking around on Google for the answer to this question, and it's beginning to really bug me. I'm making some design decisions for some code I'm writing, and I'm wondering whether...
9
by: Aaron Anodide | last post by:
Hello, I am using the following template class as a shorthand for zero-ing memory: template<class T> class ZeroMem : public T { public: ZeroMem(void)
4
by: zzfreddybb | last post by:
We are using HP aCC compiler on a HP Itanium box ( 11.23) We are having some severe performance hits using exception handling ( try/catch ) scenarios. The online aCC documentation says: HP...
3
by: groups | last post by:
Hi all, I've recently ported a rather large C application to run multithreaded. A few functions have seriously deteriorated in performance, in particular when accessing a rather large global...
7
by: Magnus | last post by:
Im using the new binding features of Visual Studio 2005. I have done the steps to create a bound data source, and selected all 40 tables from the database. The wizard generated the necessary code...
6
by: Rich | last post by:
Hi, I know HOW to run these side by side. But what is the performance impact??? Microsoft make a big deal about how it is supported, but provide no guidelines as to potential performace or...
5
by: lister | last post by:
Hi all, I have a fairly diverse range of data that I want to cache in the session rather than pulling it from the database on every page refresh. The problem is is that it seems that PHP...
14
by: Sugandh Jain | last post by:
Hi, The warning from Microsoft.Performance Code Analysis check that, its not required to initialize numeric variables to zero, boolean to false and object to null is a good one because CLR does...
0
by: jaleel | last post by:
Hi , We have a Windows service which polls a DB table and spawns separate threads for each row in the table. Each thread carries some specific information from the table.Here the requirement is we...
0
by: amollokhande1 | last post by:
Hi, I would like to know whether is any performance impact on sql server while using N as prefix in the sql query. For instance if have used following query to insert the data in fields of CHAR,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.