Handle huge amount of data using Java EE

We have a Java EE application that support Oracle, MySQL and SQL Server vendors.
we are using a view model to view the fetched data from DB, also using pagination in the DAO model, and that’s working good so far, but now we are working with millions of records like 10 millions, that cause to us a big problem since our application performance issues become very bad. After some investigations we had make we found that the order by in the query cause a big slowness in the DB level, but we still have to use it.

The question is : is there any technique to work with this amount of data with a good performance (response time and memory issues) ?

  • Best approach to create application to modify SSIS variables and start SSIS package
  • Sql Select top 3 per rollup group
  • How can i use int32 variables Expression builder in SSIS
  • SQL Server 2005 Currency Format with comma's and period
  • How to group by on consecutive values in SQL
  • Collation conflict in SQL Union All Query
  • System process is locking my database file MDF
  • How to merge two databases in SQL Server?
  • Can't gain access to my database created though Visual Studio?
  • T-SQL script to calculate time difference between multiple rows
  • how to use sql connection in PHP to execute a query on two databases
  • subselect vs outer join
  • One Solution collect form web for “Handle huge amount of data using Java EE”

    If you use ORDER BY clause frequently you should create an index on field your are ordering by. It would dramatically increase ordering performance (but of course will slightly slow down insertion).

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.