Re: WHERE 1=2 with performance nightmares
- From: "Craig Stuntz [TeamB]" <craig_stuntz@xxxxxxxxxxxxx [a.k.a. acm.org]>
- Date: 2 Aug 2007 11:20:21 -0700
Del Murray wrote:
Randomizing doesn't solve the problem because most of the time we do
this to get an "initialized" empty recordset which we can append
records into.
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
.
- Follow-Ups:
- Re: WHERE 1=2 with performance nightmares
- From: Kim Madsen
- 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
- Re: WHERE 1=2 with performance nightmares
- From: Craig Stuntz [TeamB]
- Re: WHERE 1=2 with performance nightmares
- From: Del Murray
- WHERE 1=2 with performance nightmares
- Prev by Date: Re: WHERE 1=2 with performance nightmares
- Next by Date: Re: Buying "The Tomes of Delphi, Algorithms and Data Structures" from Lulu
- Previous by thread: Re: WHERE 1=2 with performance nightmares
- Next by thread: Re: WHERE 1=2 with performance nightmares
- Index(es):