Re: Wrong results

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: simon (simon.zupan_at_stud-moderna.si)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 15:52:22 +0200

Hi,

yes the problem is when the 2 users click on the same time.
When the first user execute the procedure, can I lock table for reading,
writing or deleting?
When the first user finish with everything, then the second user can
execute.
Is this possible?

I can't cache because of dynamic.

Your solution would work but I will have a lot of data in the table then.
Is there any other idea?

Thank you,
Simon

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:uuA1AAufEHA.3632@TK2MSFTNGP09.phx.gbl...
> Why store the value at all? Is it that expensive to calculate? Could you
> cache it in your web server's memory instead of relying on SQL Server?
>
> If you absolutely must store it in the database, perhaps you should
consider
> using a table that stores rows on a per-user rather than per-application
> basis?
>
> So instead of:
>
> Orders
> ----------------------
> ProductId Quantity
>
>
> You could have:
>
> Orders
> -----------------------------------------
> UserId ProductId Quantity
>
>
> This would help ensure that users don't collide with each other.
>
>
> "simon" <simon.zupan@stud-moderna.si> wrote in message
> news:OOIGO6tfEHA.556@tk2msftngp13.phx.gbl...
> > Yes.
> > It's some kind of statistic. When user request the statistic, I
calculate
> > the values and put them in one table.
> > Then I show the results from that table to user. If user click some kind
> of
> > filter on the page or sort, then I just read again from that table with
> > different sort or filter option. I don't calculate again.
>
>