Solved

JSP pagnation issue

Posted on 2006-11-10
6
180 Views
Last Modified: 2008-01-09
hi,

I have used JSP paganation but never run into this issue before. I'm reading thousands of records and creating paganation in few sec/min. on our test server, but when it goes to production server same paganation taking half hour to create ? Any idea why is so ??


thxn
PH
0
Comment
Question by:princehyderabad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:jaggernat
ID: 17917135
see whats the difference between dev and production environments. are you using same  database in both the envoronments?
0
 

Author Comment

by:princehyderabad
ID: 17917316
U got correct.

Dev env. is diff. then Prod.

Dev: Application server and DB are at one place

Prod: Application and DB server are at 2 diff. place.
0
 

Author Comment

by:princehyderabad
ID: 17917318
But what should be solutions........
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Accepted Solution

by:
jaggernat earned 125 total points
ID: 17917518
ok, i believe when you deployed your applicaiton in production server , its not able to get some references.

can you post the code which is giving erors in production environment?

0
 

Author Comment

by:princehyderabad
ID: 17918181
Error are related only to DB connection and time out but nothing like ref. other object or code problem.

#1 java.sql.SQLException: ERROR: JagConnProxy: Connection already Closed
#2 The maximum number of rows permitted on a worksheet been exceeded

Other has time out issue. Page not Found. And for few its taking a while to display pagnation...
0
 

Author Comment

by:princehyderabad
ID: 17919277
Also is there a way: let say I have 8500 records in my DB. Based on 85k its taking a while to generated paganation. Is there a way where paganation be done based on 100 records or number we provided..
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In order to fulfill our mission of inspiring learning in the technology community, Experts Exchange is launching a Course of the Month program. Premium and Team Account members will have access to one course per month as a part of their membership, …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question