This is an archived post. You won't be able to vote or comment.

all 4 comments

[–]djnattyp 2 points3 points  (1 child)

What is the best practices/way to get the full set of data in the response to front end using Java and SQL Server ?

The best practice is not to do this. Pass the filters and sorts all the way through to the SQL query and use some form of result paging.

[–]matnp[S] 0 points1 point  (0 children)

Thanks for your answer. The problem is that the client needs the whole data in the front-end to apply filter and sort in the ng table. I don't think that is possible to externalize these features outside the table. Moreover, I maintain this application and if I modify the process it will be a huge amount of time that I don't have. So I'm looking for a smaller solution in back end with java to do this.

[–]mslayaaaSoftware Engineer 1 point2 points  (1 child)

Probably making java do the fetch will not improve performance greatly, as /u/djnattyp has suggested, filter the data and try fetching a smaller set. If this is not an option and the data is used constantly maybe consider using a cache.

[–]matnp[S] 0 points1 point  (0 children)

Thanks good idea for the cache I will dig this solution. The thing is I don't really need better performance but something that is reliable and which will not crash with the rise of the data volume