Execution of .movenext

Why is this so much slower....

[woop01]

I'm having trouble getting an ASP script to execute quickly.

"SELECT Name FROM example WHERE Name NOT IN (SELECT name FROM example2 WHERE [criteria is met])"

"SELECT * FROM example"

Both statements execute quickly enough to ignore optimizing the query. However, when I try to loop through the results using a .movenext and looping until .eof is true the first query takes MUCH more time than the second.

I'm not an expert at ASP programming but I've been doing it for a few months now. Any advice would be greatly appreciated.

[makeupalley]

try this:

[4guysfromrolla.com...]

[woop01]

That works quite well, but isn't quite appropriate for this query. I'm just wondering why the first query takes so much longer to loop through than the second even when they both return the same number of rows.

[makeupalley]

why do you say that this "isn't quite appropriate for this query"?

[woop01]

Because on each row there is an if statement that formats various rows and also sets up form inputs.

[makeupalley]

[aspfree.com...]