File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
Getting slow to load the data
Joined: Mar 18, 2011
Jan 12, 2012 06:06:55
i have written a hibernate query to get the data from MySql like this
Calendar cal = Calendar.getInstance(); cal.add(Calendar.DAY_OF_YEAR, -1); Date maxModDate = cal.getTime(); Query q = session.createQuery("from CompSubscription sub where sub.companyInfo.companyId='"+comp_id+"' and sub.subscEndDate >:maxModDate "); q.setParameter("maxModDate",maxModDate); List<CompSubscription> listCompSubscription = q.list();
from that list i am displaying data in jsp through
. It is tacking 2 to 4 minutes to execute query and data is displayed in
I agree. Here's the link:
subject: Getting slow to load the data
display all items from a list
a question on data submitting
Please help with pagination in JSP?
code to retrieve result from databse which are selected in the list box
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013