Re: 1000 select queries vs 1 ( select .. in ) query

[Peter Brawley]

Usually you'd write something like ...

elect * from topic where user_id between 1 and 1000;

... or ...

select * from topic where user_id <= 1000;

SQL parsing engines optimise for such range searches, you might want to read about range optimisation in the manual.