Many server queries or not, for a single web app?

79 Views Asked by EricF At 18 April 2025 at 10:10

I'm new to web app development, and I try to make it as fast as possible. I have 2 choices:

I can fetch all the data from the database one by one every time I require a refresh from the app,
Or I can fetch all the data in an array an work with the data "locally". The size of the array is around 800kb so it shouldn't be a big deal for the browser's cache.

I'm working with WebFocus, and the requests are made in pure SQL.

There are 1 best solutions below

MThiele On 22 August 2018 at 12:33 BEST ANSWER

It's no problem for a SQL Server to deliver the data each time.

Just make sure, that you only fetch the data you need and that you connect only once to your SQL server.