mORMot Open Source

Surely, I agree fully about NativeInt and RowId. It is more common to be able to store negative ids if needed, than unsigned int32 (in case of 32 bit compiler).
Actually, already changed to use Int64. No problems so far, maybe some penalty from RTTI dealing with tkInt64 instead of tkInteger. But think it is a peace of cake in real-life.
Thanks.

Hi ab,

Event Sourcing is very interesting topic.
Everyone faced the problems and solutions described.

Reading about Event Sourcing I realize I had implemented it in my own custom way (regardless all the theory).
Will be glad to see your approach and realization.

Fast in-memory database engine is the first thing I may use. Due to the missing in-memory indecies of TSQLRestServerStaticInMemory I dropped it.
Also, implementation can benefit using custom thread data(event) management system, build on SRW Locks. Will break legacy OS.
In any way, the speed and scalability of event backend processing may be the key when taking decision whenever to use such approach.

Will be glad to share my ideas, plans and current sources to mORMot framework, if you find them useful you will need to document and provide some good examples.
They are not so tight around the theory, but may help mORMot users in various use cases.

Wow, last time I checked Smart Studio (less than a month I guess) it was alpha and not available for download.
Arriving just in time, will give it a try.

I am using Delphi X2 Upd1, compiled both logging application and LogView.
Where I can send or post the log file and usage description? Maybe an email?

Got it.

define:
fKeySelectRequest: TSQLRequest;

on create:
fKeySelectRequest.Prepare(fClient.DB.DB, 'SELECT ID FROM TABLE WHERE COL=@1');

on destroy:
fKeySelectRequest.Close

is leaking if no step iteration called.

Did not played much with nod32 options.
There are exclusions list for specific domains, which can be set for not scanning. Did not tried adding localhost or remote one in exclusion list.
Also disabling in-depth heuristics and advanced heuristics may lead to much better performance, as nod32 will not try to interpret custom compressed content as binary executable and try to detect low-level malware code inside the "unknown" binary content type.
By default HTTP checking is enabled only for "80, 8080, 3128". I used two >1024 different ports for tests, but there is no effect till whole HTTP checking is disabled.

My use case is not common.
On middle-tier it is more like data processing than ORM, but think I can benefit from using ORM framework, even if I may had little performance impact compared to current custom realization.
On server side I had dozen of tables, few of them with a couple of millions objects. Nothing special. Here I will benefit from using mORMot, with fast SQLlite3 engine and caching. RESTful services are what I need there.
But, middle tier need something fast, in-memory indexed realization, which receive from programs (clients) around 300-500k of new generated objects (only content, no internal ids) every 5 minutes.

Must check:
Does already have them in-memory with assigned server id?
  yes (99.9%): check if content changed
    yes, changed (<1%): update the object to the Server tier, using known id and new changed content
    not changed (>99%): do nothing
  no (<0.01%): add them to the server, store in-memory the content along with new server id

As far as new and changed objects are very little % of all processed incoming objects I think it is good to be separate tire.
If cache is good enough it will be easier to use client-side cache of server objects, but I guess the purpose of the cache is other, and realization is not fast enough to process such number of objects efficiently.
I would like to implement it having mORMot functionality, maybe bigtable is suitable for this midware? Or other mORMot implementation?

Yes, sometimes I use proxy, this is the first thing I checked then I saw the problem. But proxy is not configured right now.
May it be the case? Maybe if there is a way to reset all WinHTTP settings will be good.

Will try to find out the exact problem, because I want to get familiar with the framework and give it a try even in production.
Also will be more than happy if I got a chance to contribute.

Thanks, will try also WinINet and WinSocket with the same tests and let you know the results.

I am running Win7 64bit, Delphi XE2 Update 1.
Already running latest version from fossil. No other(old) versions around.

Last 10th test failed, in TTestLowLevelCommon._IdemPropName, found in SynCommons.pas:
22546: Check(UpperCaseU(WinAnsiToUTF8('aйзD'))='AECD');

My default locale is Cyrilic (Win-1521).
Tried to convert the SynCommons.pas directly from IDE to UTF8 (File Format), also to add UTF8 BOM to get the IDE read it as UTF8 text. Same failed results.

Could this be the problem?
If yes, how can I get around this?

Other tests are also failing (pdf; one client-server test lasts forever). Will post them once I resolve this issue. I guess all the fails may be related to the problem above.

Thanks.