steve_45 Posted December 22, 2016 Share Posted December 22, 2016 We want to make a bigger project with a jasper-report-server.There will be approximately 1 Million Records a Month with we want to display in Reports and OLAP.The Goal will be not fast Transactions (read/write) but fast querys.Wich database management system and wich hardware Configuration you would recommend for this project?Best Regards and thank you Link to comment Share on other sites More sharing options...
hozawa Posted December 23, 2016 Share Posted December 23, 2016 I haven't tried too many databases but I would recommend Oracle. Remember, performance is highly dependent on how database and tables/indexes are structured as well as the sql statements.Recommend that you get a good professional database person in the project. Link to comment Share on other sites More sharing options...
marc.benstein Posted December 24, 2016 Share Posted December 24, 2016 PostgreSQL is a great as well as free option to evaluate https://www.postgresql.org/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now