[RESOLVED] Urgent Advice - recordset.filter vs. new query

[RS_Arm]

Hello guys.
I'm really needing an advice.

Question:
What is faster, use recordset.filter or make a new query with my parameters?

Example:
With some calculation, this one here takes me +- 7hours to process 300000 lines

Pseudo-code from my real code, not tested

'...
for i=1 to 300000
   rs.Execute "select id, desc from table where id=" & i 
   '...some processing
next i
'...

or

'I just can't test it, no time for it

'...
rs.command "select id, desc from table"
for i = 1 to 300000
   rs.filter = " id  =  "  & i
   '... some processing
next i
'...

Oh, by the way, my db is based on MS Access2000.
For more details in database querys, please go this is my other thread, trying to resolve this with some Voodoo-SQL:
http://www.vbforums.com/showthread.php?t=499176

Without this, the entire process (process 300000 rows) it only takes me +-10minutes.


Thank you once again for your help.