Re: WHERE 1=2 with performance nightmares

To get the layout?
The fields could easily be a combo of a join, perhaps dynamically created by
the input of a user.

Its perfectly valid to only use the metadata and return no records.
If a db does a full tablescan, then its a flawed optimizer.
Doing where true=false is in no way different to doing
field=somenonexistingvalue in the sense that the result is supposed to be
the same, the constraints are the same, the results from a stored procedure
point of view should be the same etc.


--
best regards
Kim Madsen
kbm@xxxxxxxxxxxxxxxxxxxxxxxxx
www.components4developers.com

www.myc4d.com - Your access to cool code
blogs.myc4d.com - Your access to code tidbits and comments

The best components for the best developers
Application server enabling technology for developers

Also, on further thought: This is arguably a bug in TDataSet, not in
IB. There should be a way to Insert without having to Open first. Why
do a nonsense SELECT at all?

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt
your DBs! Open Edition users, get 6.0.1.6 from http://mers.com



.

Relevant Pages

  • Re: kbmMemTable v. 5.70 has been released!
    ... Because of that I gave you the information about browser and OS. ... blogs.myc4d.com - Your access to code tidbits and comments ... Application server enabling technology for developers ... Believe it or not - the web design managed to make me overlook the shop ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Looking for super fast CSV parser
    ... blogs.myc4d.com - Your access to code tidbits and comments ... Application server enabling technology for developers ... I'm going to have to look for faster StrToFloat() and EncodeDate(), ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Need MemTable Recomendations
    ... blogs.myc4d.com - Your access to code tidbits and comments ... Application server enabling technology for developers ... do a Select to load a MemTable with the data I need to edit. ... creating the SQL update statement is of greater importance. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: WHERE 1=2 with performance nightmares
    ... even before actually searching records. ... Another way is where true=false (similar, but no potential ambiguity). ... blogs.myc4d.com - Your access to code tidbits and comments ... Application server enabling technology for developers ...
    (borland.public.delphi.non-technical)