12
Apr
09

Ajax Implementation and Data Refresh from Database

We are working on enhancements to the search optimization of an online order management system.  The suggestion to work on Ajax implementation was on hold during earlier discussion with the Customer as  due to the complexity of the reference search page particularly on the pagination links and its navigation to other screens.

We have identified the benefits of Ajax implementation for the current application as follows:

  1. The search criteria refresh can be avoided on upon clicking on Search button.
  2. The Search criteria refresh can be avoided on upon clicking on the page number links in the pagination.
  3. Look and feel of the web portal is being maintained as it is.
  4. Facilitate the multiple characters search from the drop-down list boxes.

We also analyzed the data refresh from the Database upon clicking  of the page number hyperlink in the pagination.  The current system works in the way that after the results are retrieved and when the user clicks on  of the pagenumber hyperlink in the pagination , it executes the query to the database and then the results are retrieved.  We do not stored the complete result set i.e 2000 rows into the session memory.  In general data storage in the session will improve the performance but due to the Tomcat memory’s limitation, the system may run into ‘Out of Memory’ error and also to consider the number of the cocurrent users are high in the long run.  As such, we suggested to the Customer to stay on with the current logic and work on the infastructure upgrade instead.

Advertisements

1 Response to “Ajax Implementation and Data Refresh from Database”


  1. May 4, 2009 at 11:06 pm

    Hi, nice post. I have been thinking about this issue,so thanks for posting. I will certainly be subscribing to your posts.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


April 2009
M T W T F S S
« Mar   May »
 12345
6789101112
13141516171819
20212223242526
27282930  

Categories

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 443 other followers


%d bloggers like this: