Getting records from Database

Hi
I have 12 Lac record in mysql database. I have to fetch all records.
I am using connection pool.
Also I have set fetch size property.
But still it take too much time.
Can any one tell me how to optimize that code.

Recommendation:
it will slow down your system also not only your application, so fetch the
records depending on conditions rather to fetch and then check certain
conditions.or if u are fetching all records for viewing purpose then use
paging technique, means on first page first 100 records then on second page
200 records e.g.

Hi,
I strongly suggest mairymano¹s suggestion of using pagination. Using caching
might reduce your execution time 1/3rd. Also you can reduce using objects
inside iteration. Bacause object loading is actual time consuming.
Thanks and regards,
Arunachal

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.