Hello all,
I aplogize if this has been covered - just point me in the right direction if it has been discussed.
We are just beginning to scope out the hardware requirements for database and warehouse. The basics are that the data will be stored on a DAS, with PostgresQL as the database. We expect roughly 300 simultaneuous users - all pulling. We will have only one administrator adding data to the DB. The database will have roughly 10 million fields split up between about 10 tables. These will be indexed. In addition, we will need moderate response times - on the order of a few seconds.
Based on query complexity (number of joins, etc.)for the average query - are there rules of thumbs to the speed of the servers required? What questions should I be asking?
Also are there some sites that are good reads for this area. I'm "semi-technical" more on the business side. Our IT guys would love all the iron they can get...
I aplogize if this has been covered - just point me in the right direction if it has been discussed.
We are just beginning to scope out the hardware requirements for database and warehouse. The basics are that the data will be stored on a DAS, with PostgresQL as the database. We expect roughly 300 simultaneuous users - all pulling. We will have only one administrator adding data to the DB. The database will have roughly 10 million fields split up between about 10 tables. These will be indexed. In addition, we will need moderate response times - on the order of a few seconds.
Based on query complexity (number of joins, etc.)for the average query - are there rules of thumbs to the speed of the servers required? What questions should I be asking?
Also are there some sites that are good reads for this area. I'm "semi-technical" more on the business side. Our IT guys would love all the iron they can get...