Maybe a n+1 select problem

agori · **Posted:** Mon Nov 15, 2004 4:46 am

I have an array of Identifiers and i want to retrieve all the objects (of the same class) associated with that IDs.
Which query would be efficient for this job?

christian · **Posted:** Mon Nov 15, 2004 4:51 am

"WHERE c.id IN (:idlist)", Query.setParameterList();

christian · **Posted:** Mon Nov 15, 2004 4:52 am

Note that this has size limitations for the parameter list, depending on your database.

agori · **Posted:** Mon Nov 15, 2004 3:21 pm

christian wrote:

Note that this has size limitations for the parameter list, depending on your database.

Thanks a lot!
I think i will use the parameter list, but with 10 parameter for every query.
And i iterate this query untill the index is at the end of the list.

michael · **Posted:** Mon Nov 15, 2004 7:06 pm

Not that database-limitations for this are more in the 1000 ids area.