Re: Math Operations - DB or App? - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Math Operations - DB or App?
Date
Msg-id b35603930605091455u3554e13eq526c32b57dee32e7@mail.gmail.com
Whole thread Raw
In response to Re: Math Operations - DB or App?  (Sean Davis <sdavis2@mail.nih.gov>)
Responses Re: Math Operations - DB or App?
List pgsql-novice
On 5/10/06, Sean Davis <sdavis2@mail.nih.gov> wrote:

> > With which operations/what number of calculations does
> > the CPU load on the server become a problem, though (compared
> > to the network-traffic caused by having it on the client-side)?  I can
> > think of a few applications/implementations that I wouldn't want to
> > be running on the server - where to draw the line?
> I would imagine that the answer is very complicated.  There are a lot of
> details in application design that are being ignored by my answer above.
> For example, can data be cached effectively on the client side (or in a web
> app, on the webserver)?  Is the app DB intensive (lots of concurrent
> read/writes) or are there monstrous queries running on the DB all the time
> (data mining app, for example)?  There are many points that do and should
> influence application design, so benchmarking, knowing user needs, hardware
> and software constraints, and maintainability all play into the answer, I
> think.
>
> Not an answer, I know....
I wouldn't say that :} ... it's pretty much exactly what I was hoping for,
namely that there *IS* no answer, and that it always depends on varied
factors which need to be evaluated for each individual case.


> Sean
Cheers,
Andrej




--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Math Operations - DB or App?
Next
From:
Date:
Subject: Re: Math Query Help