How to speed sql Statements?

[bezudar]

i used batch in inserting values in db but select statement is taking time cos i have to do it one by one and that is taking time Is there some way i can execute select statements in batch and then get an array of resultsets and use them

[masijade]

It might help to know what it is your actually doing. Selecting a single row at a time is not the norm, so your question, as is, doesn't make sense.

[bezudar]

oh sorry i am select an entry from one single column
"SELECT (test) from TEST_NUMS where test=? AND test<=?"

[masijade]

You do know that the second part of the where clause is not necessary, and makes no sense in relation to the first part, right?

In any case, I meant you need to explain exactly what it is you are doing. What are you doing with the "selected" row and how does it relate to the insert, and what is the insert query?