Polite use of Servers 1

[Remou]

Hi: Even though my site is only for very few people, I would like to use the server in a polite way.

Is it very wrong to say:

Do While Not rstA.EOF
   SQL = "SELECT ... WHERE Code=" & rstA.Fields("Code")
   rstB.Open SQL, dbCon, 3, 3
Loop

?
Thanks

 

[pkailas]

Well as long as you don't type:

Do While Not rstA.EOF Idiot!

Ok, Ok, that wasn't polite to rstA at all, was it?

but no, honestly, your code is fine, however if you can do a join instead of nested loops, you'll find the performance to be quite a bit better.