Getting slow to load the data

[mallikarjun dontamsetti]

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 servlet. It is tacking 2 to 4 minutes to execute query and data is displayed in JSP.