i had implemented aws elastic service in a saas based system but when i am developing it on test server it works very well it takes avg 120 MS to give output
but when i put it on live server with large servers it goes slow with avg 500MS
the only difference is number of records.
can number of records responsible for that as i already increased server to large instances with multiple instance and also on multiple nodes but still its not up to the mark.
or what can i do to increase the performance off course search queries can not be the issue because with same query it works superb on testing server