Re: Speeding up multiple updates

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Bob Barrows [MVP] wrote:
Absolutely not. It's not the worst thing you could do, but it's close.
Almost worse than creating multiple columns to hold the individual data
values.

My solution involves a single UPDATE statement as well. And data
integrity is not compromised.

Why is this so bad? There is no validation done on the values (the
user enters the data), so I don't think data integrity would be a
problem. (Unless I'm not understanding what you mean.) Also, having
one column with delimited values seems simpler and would seem to take
less time on the database end since the ASP code would put together
(and take apart) the delimited list of values. It's not an elegant
solution, but it seems like it should work and alleviate the problems I
have been experiencing with timeouts, locking, and cascading blocking.

Brian

.

Relevant Pages

  • Re: Speeding up multiple updates
    ... Almost worse than creating multiple columns to hold the individual data ... integrity is not compromised. ... server-side code to iterate through variable length delimited lists to get ... If the requirement changes such that a stakeholder in the ...
    (microsoft.public.inetserver.asp.db)
  • Re: adSeek equivalent in SQL Server?
    ... You can use criteria on multiple columns when setting the Filter property ... Brendan Reynolds (MVP) ... > expensive to open and close the record set everytime. ...
    (microsoft.public.data.ado)
  • Re: Install KB908531 and edit registry or wait?
    ... Today Ronnie Vernon MVP commented courteously on the subject ... Security Bulletin Search: ... As to doubting the integrity of MVPs, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: XP on multiple systems
    ... Jupiter Jones [MVP] wrote: ... the agreement cannot be made until it's too late to get your money back. ... What kind of integrity is that? ...
    (microsoft.public.windowsxp.general)
  • Re: Filter Form on multiple criteria
    ... For> example, let's say that I wanted to look for a specific> datein multiple columns. ... >>Alex Dybenko (MVP) ... >>> This is probably a stupid question, but is there a way> to filter a form so ...
    (microsoft.public.access.modulesdaovba)