470,614 Members | 1,488 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

bug?

Hi,

I don't know if it is a bug, but when I try to run to
following query on a DB with 2100 (fonds_tbl) and 6100
(fonds_name_tbl) entries I can see the memory use
increasing and in the end the query is aborted due to
a out of memory message. And I have about 768 MB of RAM.

select * from fonds_tbl where fonds_tbl.isin != fonds_name_tbl.isin

But if I try:

select * from fonds_tbl where not in (select isin from fonds_name_tbl)

it works fine.

Can't remember exactly if those were the statesments but in fact
I just tried to select the entries which are not in both tables.

Cya

Andreas
Nov 11 '05 #1
0 1041

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.