26
Jan
09

Application-Search Optimisations for Web Application

Last 2 months we had been concentrating on the application performance, in the midst in resolving the network issues.

Findings that the SQL-Server and Web server seems to be as disadvantages for the Application.  The allocated memory-settings caused some swapping, which lead to additionally and slowly I/O. The current memory-settings are not useful for any productive running and there may be some memory hip-cups during our testing.

We performed the page loading’s responses time in 2 criterias by one full search  and a partial search (limit the nos of records shown in per page).  The outcome of the test results for these 2 criterias are different.  One possible reason is that the used SQL server does not support paging.

When we load the first 30 records the used SQL-Statement produces a searching result of 36.34 records in the database. I assume, that during the build up of the side (through the application) all 36.34 records will be used to identify the first 30 references. The rest of the 36.34 records will be dismissed afterwards. This assumption is leaned on the result, that when demanding the next 30 records, the same SQL-Statement turns towards the database and – again- the outcome are 36.34 references. This is caused by the used SQL-Server, which does not support any LIMIT-clause within the SELECT-Statement.  From this investigation there may be some redesign of the application OR the switch to some other SQL-Server to remedy the problem.  Redesign of the application seem unrealistic, as the application is still new, likewise switching to another SQL-Server needs to be evaluated in a detailed manner and could indeed be some realistic option.

Advertisements

0 Responses to “Application-Search Optimisations for Web Application”



  1. Leave a Comment

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


January 2009
M T W T F S S
« Dec   Feb »
 1234
567891011
12131415161718
19202122232425
262728293031  

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: