Hi,
Since you have over 10,000 member ids it depends on
the exact appln that you have.
If the length of the SQL query increases above a
certain length (i am not sure abt the exact figure),
an error is thrown saying "query too complex".
such wont be the case in your former method.
but,
if there are n member ids to be updated, the former
update query will have to be executed n number of
times, giving n disk accesses from your VB program,
while the later query would need just 1.
So if you can guarentee that the query string will not
become too long, then the later update statement is
good.
If you are not sure, its better to go for the former
update stmt and forget abt disk write time(at least ur
program wont crash).
-Sagar
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
