Home » U++ Library support » U++ SQL » Transfer compress data
Re: Transfer compress data [message #59830 is a reply to message #59821] |
Sat, 29 April 2023 00:25 |
zsolt
Messages: 698 Registered: December 2005 Location: Budapest, Hungary
|
Contributor |
|
|
Hello Luigi,
A had a same problem, so I created a backend part for my U++ software.
It receives JSON data as arguments in HTTP and the responses are also in JSON. This way it can be used by not only my GUI app, but a Javascript SPA (single page app) also.
HTTP is good, because I put my backent behind an Nginx reverse proxy. Nginx can compress the responses.
The other problem, you can had solved with this solution is the latency, caused by multiple SQL queries. E.g. user opens a data entry window with a lot of droplists and/or converts, based on the database, that generates a lot of SQL queries one by one, adding a very large latency. Using this JSON requests, you can send all the parameters to the server (the backend) in a JSON. It runs all the queries in place and sends back all the results in one JSON, so the latency is one request-response time only.
Jsonize framework is very useful here.
|
|
|
Goto Forum:
Current Time: Wed May 15 05:55:11 CEST 2024
Total time taken to generate the page: 0.02717 seconds
|