|
|
Posted by m6s on 02/12/06 12:36
J wrote:
> "Dimitris Mexis" <m65@vivodinet.gr> wrote in message
> news:dsimlr$jrl$2@ulysses.noc.ntua.gr...
> Suppose I am only one person, and I have a database, full of
> data...thousands of lines...
> Is it a good aproach to build an environment which will calculate means,
> deviations, distributions with PHP ?
> If yes, is it good for 50 people?
>
> If not...How is the best way, having in mind that I want to make it "web" ?
>
> ****
> It depends.
>
> Try to describe a more specific "use case" or scenario.. what will these 50
> people be doing?
>
> What kind of machine are you rrunning? an old pentium 2 or a newer one?
> Is the "server" actually a desktop that's being used for other things, or is
> it dedicated to this task?
>
> Keep in mind.. you could try your calculations within sql queries and thus
> make the database engine do it, OR you could ask the php module to get ALL
> the data from mysql and calculate it outside...... I'd let the db do it:
> "select AVG(Column3), STD(Column3) from table" Php will send this query and
> grab the results. Boom, it's 'web'.
>
> -J
>
>
In deed, I followed this approach but my pentium ( which is a celeron
366 older celeron ) gives results after 0.04 or 0.09 seconds...
In any case I think it;s not a bad idea from mysql, if I would let the
php do it alone, I think the web server would get unresponsive till the
moment it would end the calculations right?
Navigation:
[Reply to this message]
|