I have some code that loops through about 1/4 of a million records, it is taking a very long time (I stopped it after 15 minutes and it wasn't close to done).



I took out all the processing in the loop so that all it was doing was the loop with a single seek() and it was still slow. I replaced the seek() with "if 1 =2 then" and it went as expected (about 20 seconds).



I am seek()ing against a single integer field that I have an index on in SQL. Help????



Code:

searchstr = "rent_RPMrecnum = " & "'" & currow("record_number") & "'"

'If Me.RentitemsBO1.Seek(searchstr) Then

‘do nothing

Else

‘still do nothing for testing purposes

End if





Thanks.










Keith Chisarik

What's a punch card? 

1983 - Keith was 10, Trent was 7, Ben was 2 -- ok I am a little older than you guys -- by a freaking lot. I was 31 in 1983.

Either y'all are precocious or maybe I am mature.  Actually, I started on punched cards and tape.  At one time I could read Baudot...

I think Ben and Trent are counting the days until the nursing home comes and gets me...

 

I was 19. But I'm not worried... I've decided to live 120 years, so, nothing to worry about.

Steve, it's great to see you active in design and development. And that's what keeps everyone young...Staying on top of things.



Hope to see you when I get to your class!

..ßen