I hv created a software which searches for the information the user wants.
If only one user is using database at a time then it gives response in milliseconds.
But when at a time 10 or more than that start using it then throughput decreases.
So how i should do optimization
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!