For application performance you need to some r & d on your query mean stored procedure see their retrieval cost and find where it is taking too much time to retriev the data and do some action on that table. For eg. 1.You should be use index whereever required 2.Use joining if required otherwise remove unnesseary join. 3.Select only required field from table. 4.you can using caching 5.Create index for the table field which you are frequently using in where clause.