It seems to me, that using Xojo to create a webservice on a Linux machine, which makes use of JSON, is a complete no-go, because it is unacceptably slow.
If you want to get some database data via a linux webservice to your iPad or desktop app, then you probably need to look for other options than a Xojo webapp.
Kem Tekinay reported the issue, which he noticed on Windows, last year and he created a testapp which can be downloaded from feedback:
<https://xojo.com/issue/45229>
I did run Kems test as a standalone webapp, in macOS Sierra, on Windows 10 Creator and on a Ubuntu Linux vps.
What seems to run well on macOS is extremely slow on Windows and far off on Linux:
The app creates a large JSON text, then times how long it takes to parse it:
macOS Sierra 10.12.5: 0.75 seconds
Windows 10 Creator : 16.2 seconds
Ubuntu Linux 14.04 : 48.8 seconds
Well this is odd. Using a VM running Mint 18, I cannot reproduce your results. The parsing takes 0.65 seconds, give or take, on both Mac and Linux. Trying Windows 10 now…
I’m at a loss for what I’m seeing. My original test project (desktop) shows the same slowness on Windows and Linux, but your project, Oliver, is speedy on all platforms.
Oh, of course, it’s an ID-10-T error. I was running in debugging mode so naturally the web pages on Windows/Linux were going to reflect the faster time of the Mac.
I have a webapp running on that server, which makes use of json (but sending only small junks of information around), which is much more responsive: https://lic.seminar.pro
Oliver, have you tried my JSONItem_MTC replacement for JSONItem? I think you’ll find the performance acceptable until the new framework text handling is fixed.