Subject | suggestion for a db scenario |
---|---|
Author | Francesco Lamonica |
Post date | 2011-06-14T11:35:21Z |
Hi all, it's been a while since i last used FB (not that i used
anything else :) but i have not been involved with DBs :))
Now we're planning a project with hundreds of clients (think 5-600)
that will do insert queries every minute or so (to save status data)
over WAN and one or two clients that will do select queries to plot
this information, think of: select avg(myval) from table1 where
"timestamp<15min ago"
Since the stored data will grow quite fast (we need to store a few
months worth of data) have you any recommendation on which kind of
architecture (both HW and FB) would be suitable?
thanks for your insights :)
anything else :) but i have not been involved with DBs :))
Now we're planning a project with hundreds of clients (think 5-600)
that will do insert queries every minute or so (to save status data)
over WAN and one or two clients that will do select queries to plot
this information, think of: select avg(myval) from table1 where
"timestamp<15min ago"
Since the stored data will grow quite fast (we need to store a few
months worth of data) have you any recommendation on which kind of
architecture (both HW and FB) would be suitable?
thanks for your insights :)