Hi,
I am building an API using delphi 10.3
The technology that I am using is datasnap web broker stand-alone application.
This API handles a web request that post data to my SQL server database.
The response I am returning is in JSON.
It works, but I am concerned about concurrent requests and a heavy load in general.
Also, at some point I will create another API that generates PDF file and sends it out to the client.
Should I use another type, like CGI or ISAPI?
Should I create connections and queries in code at runtime before each request and then free?
I am new to all this and still learning.
Can anyone please guide me with the technology that I use?
Thanks,
Marian