Re: WHERE 1=2 with performance nightmares



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
.