|
| WD23 Mobile Webservice vs Stored Proedure |
| Iniciado por guest, 20,jul. 2018 19:25 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 20,julio 2018 - 19:25 |
I was thinking and am wondering the pros and cons of this.
If you have a mobile device that needs to send a small amount of data back and forth could you do it with stored procedures.
Stored procedure:
Create a set of procedures that will take a JSON string as a parameter process all of the hreads hsaves on the server and send back a string result if any error occurred.
almost the same thing as a web service but without the web server overhead.
Could this work?
DW |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2018 - 19:32 |
Hi Dennis
a stored procedure is NOT something made to wait for it and retrieve a result. It's made for DB maintenance or statistic calculations...
furthermore, what you are describing is no better than to directly read an write in the DB and subject to the same problems of connection quality on mobile.
So while it's PERHAPS technically possible, it is one of those false good ideas... You are adding complexity without solving any problem, or in other words, for no good reason).
The web server is NOT any overhead, it's a solution.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2018 - 20:05 |
Hello Fabrice,
Why I think of this route is that most of the people using my program do NOT want to expose their network to the internet via a web service.
DW |
| |
| |
| | | |
|
| | | | |
| | |
|