|
-
May 14th, 2006, 01:56 PM
#18
Re: SPROC and VB6 Question
The speed difference of a loop is so meaningless compared to forcing the whole recordset to come from the client and be memory resident (or paged to local disk) just so you can MOVELAST and MOVEFIRST to get the recordcount.
That MOVELAST operation could be noticeable to the user.
We always choose the DO WHILE/rs.EOF technique.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|