mORMot Open Source

Another question,

I was using "UseCache=True" on server side (mormot) wich gives amazing performance, however when I pump new data, the server don't show it becuase it's using cache.

Is it possible to update the cache? Tried to reset cache, but didn't work.

I have to disable it and lost some performance.

Hello Ab!

1. Sorry, it won't happen again

2. Done

3. Done

4. Do you mean to use another protocol (I'm using :RestServerSettings.Protocol := HTTPsys;)

5. Yes, reads, my clients only receive JSONRaw (most clients just view data from current day, but some analyze few months and in this case I copied the result json into file to get the size and got 33Mb, I will talk with them,
maybe they don't need all data but just summary)

6.  Do you mean the code (I show just part because of forum rules)
    function TRestMethods.GetData(DateStart, DateEnd : RawUTF8): RawJSON;
     begin
    Result := RestServer.fDatabase.ExecuteJSON('..',True);
     end;

7. For now, I didn't put because it is for use only on our intranet, but it is also a future requirement, what the best way to do it ?

Ab, thanks for all your help and the time helping me.

Best regards.

Hello Ab!

Good news!

It's working, tested with 50 threads/100k requests, got zero errors, even with the server under stress, tested my client app and tested via browser URI with amazing performance.

I was testing with RestDebugger witch gives full response format.

I changed my client to use the interface (with parameters now ;-)) and WORKS!! The response is the expected.

On my client, I'm loading RawJson into memtable with "LoadFromJSON()" from DataSet.Serialize.

Mormot have deserialization with the RawJson I receive on my client, produced by "ExecuteJSON"?

Best regards.

Ab,

is DONE ;-).

Is it right to use RestDebugger to test my Server Methods results?

The results I receive are not the expected.

O I'm doing something wrong, or I cannot use it and I must create an tiny client to test with my interfaces?

{   
"result": [
        [
            {
                "DATA": "2019-10-11",
                "HORA": "15:24:57.000"
            },
            {
                "DATA": "2019-10-11",
                "HORA": "15:27:29.000"
            },
            {
                "DATA": "2019-10-11",
                "HORA": "15:29:34.000"
            }
        ]
    ],
    "id": 10916
}

Why is that "result" and the "id"?

Thanks ab!!!

You mean one connection to sqlite for all client requests, right?

Best Regards

Hello igors233,

Thank you very much for your attention.

I'm a Delphi developer. My clients are developed in Delphi also by me, so if needed I can also adapt to mormot.

I started with the sample "..mORMot\SQLite3\Samples\ThirdPartyDemos\George\REST-tester", this is an interface-based-services, right?

Since my firebird database is hudge, I created an local sqlite database with the only table needed, I pumped all data from firebird to sqlite and periodically I update that local bd.

Now, in mormot I don't now wath to do :

Put my local db in memory RAM (how?), create class ORM for my table? My interface must have dedicated connection to my bd and run sql to deliver json to client? or use only one connection for bd?
There will be 300+ simultaneous connections, this will be thread safe? Concurrency safe?

The functions on service must receive parameters (start and end date), how to do?

I want the best performance, so i need to do the right way, but since i'm starting and there are multiple choices, i need your help.

Thanks,

Best regards.

Thanks ab for your attention.

The challenge is to convert Datasnap to mORMot. With Datasnap it was quick to develop but has many performance problems and stability issues.

"But instead of using SQL from the client side, which may be unsafe, I would rather define several dedicated methods, depending on the use case."

I agree, I want to execute all sql on the server side from local sqlite bd (or load the bd into memory ram).

To my clients, I just want to deliver JsonArray (clients are already rest clients, but I can change for mORMot).

So I have a local SQLite database (maybe load it into memory RAM, need advice about best practice and how to do it), then I will have an interface service with 3 functions with 2 parameters each (start and end date),
this functions will execute sql on that database and retrieve results to clients as jsonarray/binary/other (what is the faster?).

Thanks,

Best Regards.