Re: WHERE 1=2 with performance nightmares


"Kim Madsen" <kbm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46b0f077@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

Sounds like a where clause added by an api or middleware to get the field
definitions but not any records.



Is "1" and "2" supposed to be the respective columns in that queried table?
If so, then "1" may well equal "2" at any given time for any given table...

If both columns are integer-based IDs, then this is likely. It could even
explain the percieved performance hit.

It looks like Ralf Jansen has good advice on how to disable the "SET FMTONLY
ON" behaviour.

-d


.

Relevant Pages

  • Re: Why only .NET or only WinAPI?
    ... Could you elaborate on the acronyms "ISVs, IHVs, IAPs, ICPs, and OEMs"? ... Also, the term "Middleware" seems rather somewhat nebulous and vague to me, ... Since this MS API ... Product uses to call upon that Windows Operating System Product in order to ...
    (borland.public.delphi.non-technical)
  • Re: Intermittent GPV...?
    ... NIC card set to 'allow OS to put to sleep to conserve energy'? ... Form/library with API USES clause, ...
    (comp.databases.paradox)
  • Re: Embrace and Extend, Borland Style
    ... I don't see a conspiracy under every rock. ... The antitrust settlement forces MS to publish every API that could ... be used or is used for "middleware" (see the settlment for what middleware ...
    (borland.public.delphi.non-technical)