Re: Wrong results

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 09:43:19 -0400

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.

Relevant Pages

  • [8FOLD] Template #3
    ... "You lead a very eventful life, don't you, Mr. Kidman?" ... lunatics collapsing in the middle of your store... ... threats have some sort of motivation behind them. ...
    (rec.arts.comics.creative)
  • Re: Bad feelings in Wickes
    ... to sort it out. ... insisted that I should approach the exit without the carrier bag, ... test if the machine would beep. ... A few years My brother and I went into a Wicks Store and bought a large ...
    (uk.legal)
  • C 128s ROM socket
    ... sort of a new topic, so I didn't reply to that. ... I've thought about that ROM socket in the C128 a lot and have on occasion ... So I'm hoping to use something on the IEC port to store more ... up trying to read/write to a serial flash ram chip via the user port.. ...
    (comp.sys.cbm)
  • Re: all this talk of clothing made in china...
    ... USA." and in her store, she's only going to sell items that are made ... and just the sort of person that should think about joining the ... I was brought up by parents (mother, mostly) who instilled me with all ...
    (uk.people.support.depression)
  • Re: OT: Materialism and reproductive success.
    ... My fear is that this sort of behavior is growing rather than ... matches in the store at Christmastime over who could take the last one. ... Robert Grumbine http://www.radix.net/~bobg/ Science faqs and amateur activities notes and links. ... Sagredo (Galileo Galilei) "You present these recondite matters with too much ...
    (talk.origins)