my requirement is to get rows (it may be 1 or 2 or 100 or 1000 or xxx) from the database, primary keys for all the rows will be available for me but mostly they will not be in serial.
so my concern here is how to get the data from the database.
approach 1: Get each row at a time (but in this case I have to execute select xxx times and may be every time I have to get the connection and close it)
approach 2: Get all rows in one select query, but I have to append xxx or's in the where clause. Even if I do it what would be the max support of or's in the where clause and even if it supports some 5000 or 10000 or unlimited, is it a good way to do it.
Is there any other good or best way to get the data for this type of situation.