kishorgite
Member
we need to reduce execution time for our BSSV .
We are passing array of 20 item for which we need to retrieve advance price .
We used standard BSSV with some modification (that was for only one item ,we added array in it for 20 value)
It is taking 38 sec to retrieve advance price ,our client want that result in 5-8 sec .
Can some one help or suggest option so that we can increase performance of BSSV .
will it helpful to try some high performance server or change in server configuration .
Right now we are trying to optimism code with removing unnecessary nested call and increasing attributes in where clause wherever database call exist .
Thanks in advance .!!!!!
We are passing array of 20 item for which we need to retrieve advance price .
We used standard BSSV with some modification (that was for only one item ,we added array in it for 20 value)
It is taking 38 sec to retrieve advance price ,our client want that result in 5-8 sec .
Can some one help or suggest option so that we can increase performance of BSSV .
will it helpful to try some high performance server or change in server configuration .
Right now we are trying to optimism code with removing unnecessary nested call and increasing attributes in where clause wherever database call exist .
Thanks in advance .!!!!!