Hi,
Hope you are doing well.
I have gone through the requirements and found you are facing issues in SQL queries. I have worked on business intelligence reports where millions of records are fetched with high calculations within seconds. Yes, there is a way to design queries so it can't take more than 1 or 2 seconds with calculations. all depends of query optimazation. query optimazation can be done by using query optimisers, and some indexing in database tables to boost the performance.
We are highly qualified and experienced team works on large Java based web applications using following technologies.
Java, j2ee, spring, struts, jsp, jsf, ejb, hibernate, ibaitis, I but , camel, maven, gradle, ant, mysql, oracle, mongo, json, xml, HTML, CSS, bootstrap, angular js, jquery, JavaScript, hyperjaxb3, Jersey web services and spring rest web services.
we have developed applications with following feature
secure web SSO login
user management with roles hierarchy
business intelligence reports
emailing feature
live dashboards to show live business
API integration
Please let me know how may I help you
awaiting positive response
Regards
Vishal