Re: WHERE 1=2 with performance nightmares
- From: "Craig Stuntz [TeamB]" <craig_stuntz@xxxxxxxxxxxxx [a.k.a. acm.org]>
- Date: 2 Aug 2007 09:30:58 -0700
Kim Madsen wrote:
Usually the expression compiler will evaluate the expression to be
false, even before actually searching records.
I know that to be false for InterBase. I expect that to be true for
any DB server which doesn't actually explicitly check for such
conditions. It is, generally speaking, a bad idea.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Want to help make Delphi and InterBase better? Use QC!
http://qc.borland.com -- Vote for important issues
.
- Follow-Ups:
- Re: WHERE 1=2 with performance nightmares
- From: Kyle A . Miller
- Re: WHERE 1=2 with performance nightmares
- References:
- WHERE 1=2 with performance nightmares
- From: Sarah
- Re: WHERE 1=2 with performance nightmares
- From: Kim Madsen
- Re: WHERE 1=2 with performance nightmares
- From: Craig Stuntz [TeamB]
- Re: WHERE 1=2 with performance nightmares
- From: Kim Madsen
- WHERE 1=2 with performance nightmares
- Prev by Date: Re: Screen size
- Next by Date: Re: WHERE 1=2 with performance nightmares
- Previous by thread: Re: WHERE 1=2 with performance nightmares
- Next by thread: Re: WHERE 1=2 with performance nightmares
- Index(es):
Relevant Pages
|
