SQLBase 9.0.1 INSERTs with a subselect

[Wolfgang Lackner]

 Posted by:  Wolfgang Lackner 

There is huge difference in performance with SQLBase 9.0.1 (PTF1) and all
previous databases, if you use an INSERT like:

INSERT INTO (xxx) SELECT xxx FROM WHERE xxxxx AND y IN
(SELECT x FROM WHERE xxx)

i.e. you connot use such a statement now, because it is really very slow,
even the result of the sub is null.
the defect number is 84771

[Mike Vandine]

 Posted by:  Mike Vandine 

Hi Wolfgang,

How does the time change if you modify the 'AND y IN' to use an 'exists'
clause?

Mike

[Wolfgang Lackner]

 Posted by:  Wolfgang Lackner 

hi Mike,
no problem with exists. I know that.

But:
(1) if it works, IN ist faster than EXISTS
(2) I use this statement with different DBs
(3) up to now it worked

wolfgang

[Günther]

 Posted by:  Günther 

Why not using join syntax for the query part?
Commonly this is much faster compared to subqueries with IN or EXISTS (At
least on iSeries and Oracle)
But I do not have experience on SQLBase.

Günther