what are the things we need to do (concentrate) on Database side to improve the performance of projects
and
what are the things we need to do (concentrate) on Application side( UI Layer, Business Logic layer Service Layer And Data Access Layer) side to improve the performance of projects
example :
my application page take so much time to load that means so slow , so to improve the performance
1. How to improve performance,
2. what are the things we need to do (concentrate) on Database side
3.what are the things we need to do (concentrate) on Application side
it is very urgent & impotent for me so please help me any one..