You are not logged in.
i was using VariantToInteger from mormot.core.base and i excepted that it will turn variant which can be anything with a numeric value to integer if it can. A string with numeric values still an integer imo. anyway, thanks for clarification and new function.
best regards
it's very simple.
procedure Test(const Node: IXMLNode);
begin
if not VarIsEmptyOrNull(Node.ChildValues['RecID']) then self.fRecID := VariantToInteger(Node.ChildValues['RecID']);
end;Using ChildValues returns a OleVariant type and when i send that value to VariantToInteger, V's VType is 8 which is varOleStr. there is no case for varOleStr so it falls into else case and uses SetVarDataUnRefSimpleValue and fails.
Hi,
I am working with xml nodes and when assigning some values from xml to record i use mormot's functions obviously but it seems variant conversions does not work with OleStr or OleVariant types. Value is something like '688' and there is no case for OleStr so it will use SetVarDataUnRefSimpleValue which returns false.
This is not a major problem or anything, it just catch my eye and want you to know.
Best regards.
Sure, it's done.
Hi ab,
I encountered an infinite loop while reading a zip file TZipRead from mormot.core.zip, at line 2797. This is not a mormot issue because in my case that zip file is not an actual zip file. Someone thought changing a html file's extension to zip is a good idea
. There is a function called IsZipStart to ensure it's a real zip but in this case it returns true. Delphi's TZipFile.IsValid return's false so i am using it before TZipCreate.
Anyway, an infinite loop is maybe something you want to avoid. Just want to inform you. I am using 2.4 stable release.
Best regards.
Yes, thank you ab.
Hi ab,
Delphi raises a "Combining signed and unsigned types" warning when using mormot.db.sql.zeos unit for line 393. I know it's nothing but we configured our compiler to not build applications if there is a warning.
I fixed my own copy. Here how i did it.
var
BrakedPos, BrakedPosEnd: integer;
begin
// return e.g. mysql://192.168.2.60:3306/world?username=root;password=dev
// make syntax like "ADO[ORACLE]"/"ADO[MSSQL]:"/"ADO[JET]" etc... possible
BrakedPos := PosExChar('[', aServerName);
BrakedPosEnd := PosExChar(']', aServerName);
if (BrakedPos > 0) and
((aServerName[Length(aServerName)] = ']') or
(aServerName[Length(aServerName) - 1] = ']')) then
begin
fServerName := Copy(aServerName, 1, BrakedPos - 1);
fDbmsName := Copy(aServerName, BrakedPos + 1, BrakedPosEnd - 1 - BrakedPos);
endbut i don't want to fix it every time i update my mormot2 for reasons
. I can change it and create a pull request but it's just a single line.
So, can you fixed it please?
I updated both, there is nothing on server logs except:
20260126 13490817 + EXC EOrmMongoDB {Message:"TRestStorageMongoDB.RetrieveBlobFields(TAuthUser): field [Data] not found"} [app 8] at 01350a52 {4 0.55 0.15 59 5GB/7.9GB 45631c01}which i believe is not related to this because it was there before. Since I inherted TAuthUser for my own TAuthUser class and mongodb have an issue with it.
But, i did change my SaaS server's auth imeplementation. They are all using an another client to connect my auth server to verify user. Maybe, that's the issue i will check. I will re-check mormot's auth method and implemantation to update mine.
Thanks ab, you are always so quick to resposne.
Also, sorry if this is documented or know implementation. I didn't have time to look since i am between changing jobs and my side jobs are getting busy each day. I work day and night don't have much time.
Hi everyone,
I just pull latest commits and my clients started to raise an error. It didn't break anything, process continues as it is suppose to be but i liike to know if there is a new implementation and is there something i need to do.
20260126 13265310 ! ERROR SaasApi.Client.TRadApiClient(05253a40) GET apis/rad/v4/a44eafaf573c47048e0a796efd64671f/stat/soa returned 403 (Forbidden) with message { "errorCode":403, "errorText":"URI Authentication Failed: Invalid signature (0)" }Hi everyone,
I want to upgrade my MongoDB from 4.0 to 8.0 but my old api services build with mORMot and does not support new versions of MongoDB. My new api sevices are build with mORMot2 and works fine. While upgrading my api services i need to maintain my old versions for customer work with old api services. This means i need to make them work with same db, so i decided to update mormot's SynMongoDB unit. Lot's of comparing and copy pasting from mORMot2.
You should upgrade to mORMot2. this fork is for people who are in my shoes and needs to use new versions of MongoDB with mORMot,
mORMot with updated MongoDB library
https://github.com/koraycayiroglu/mORMot
If you are referring to method based services you should not be adding or removing methods at runtime. It was not designed for it, also background logic is implemented using TDynArrayHashed which is not thread safe. I don't know what your solution is but if it's not jwt tokens it's probably a bad solution. Best regards
It's a mvc application without any authentication, there is no need for jwt or else. My solution is actually very simple. Used to use a mvc application for each instance, in this case eshot360 image with lots of js and images, to show user time limited content. I modified my code to use one mvc application and use an identifier as a uri parameter to load requested eshot360 content. using a orm class to make it time limited.
User make a api request to my server, server create's a new record for that request with the file and time info, returns a unique identifier, user mavigates to my mvc app with that identifier to see the content. after 5 minitues, that content will not be avaiablle.
It was just hard to show separate eshot360 content inside one mvc application, because it needed lots of rewrite url inside nginx to make it work. But the result is satisfying.
it's seems there is not. Anyway, i found my own solution with a different approach. Never mind this question. Thanks.
this is how i create my TRestServerDB:
constructor TCoreServiceRestServer.Create;
var Model: TOrmModel;
Cli: TMongoClient;
begin
Model := TOrmModel.Create([TAuthUser, TAuthGroup, ...], 'app');
inherited Create(Model, True);
SessionClass :=TAuthSession; // Custom TAuthSession
Cli := TMongoClient.Create(DB_ADDRESS, DB_PORT);
Cli.ConnectionTimeOut := 0;
Cli.GracefulReconnect := True;
Cli.OpenAuth('admin', DB_USER, DB_PASSWORD);
OrmMapMongoDBAll(Self.OrmInstance, Cli.Open('core')); // 'core' is my collection's name
Server.CreateMissingTables;
end;Hi to everyone,
Looking for something like ServiceMethodUnRegister but couldn't find, how do i unregister a method at run-time? In my case, i am creating mvc applications with suburi on the fly for displaying a secure content, and it will dissmised itself at a certain time period. Mvc app freed but i can't use same suburi to create a new mvc app. Also, don't wanna use more custom suburi's, like timestamped, cause this means registering too many unnecessary suburi's to rest server.
Best regards
Also, are there any examples of TAuthGroup + TAuthUser + MongoDB
What are you looking for exactly?
I try to explain my setup to you. maybe it helps.
ubuntu server with nginx, windows server with a core service for authentication and management. some small sub services for notification, file management, collection statistics etc. which have their own db. Overriding core service's auth methods to handle connections. using an inherited Authsession class to handle connections to sub services. core service handle connections.
user make an auth request to my domain.
nginx reverse-proxy that call to my core service.
core service identifiy user and authorize it through needed channel.
an authsession created with client information to sub services.
when user make an api call to core service, let's say Storage/file_get, that method create's a new client to fileserver with given information, respond to api call and free it self.
Each service have it's own taskmanager, generated from TSynBackgroundTimer for their routine processes. Only core service (and my multi-tenant services) available through internet, and sub services work locally.
I am not sure, you are looking for something like this because very need has it's own structure but as i said, maybe it helps.
This is like, chicken or the egg dilemma ![]()
oh, my bad. I thought it works as it did with mormot 1.18, never thought there will be a change like this. Ashamed of myself, usually i read everything but today is a very long day for me. So, sorry.
Hi again,
As title said, version info is empty. Using Delphi 12.3, Windows 11 latest update, mormot2 latest commit. with PUREMORMOT2 and USEPACKAGES definitions uncommented. Any ideas?
Best regards
Ok then, I just wanted to confirm. I'll check my setup.
Thanks ab.
Hi everyone, i hope you are all fine.
Are we still using the same documented versions for mormot2? I tried stable versions (FPC 3.2.2, Lazarus 3.6) but can't compile, {$MODE DELPHI} line inside mormot.defines.inc raises an errror as "mormot.defines.inc(163,6) Error: Mode switch "DELPHI" not allowed here". Disabling it raises others errors and goes on.
if anyone has an issue with this error and see a console popup when starting delphi, remove your old packages which uses mormot from ide and re-install them. it seems re-building them is not enough for delphi.
i use nginx on windows server for my customer with wildcard ssl certificate to host an react-native web application and couple of api services written with mormot with no issues. it's not designed for windows yes, but still usable for reverse-proxy. i don't know what your setup is and how much work will it need but for my own company, i installed an ubuntu server+nginx that handles requests and reverse-proxy them to my other windows servers using iss+isapi at the back-end and don't expose them to internet directly. I believe it's more secure this way.
Another thumbs up, nginx is the way to go
Alright, funny enough it fixed itself ![]()
Updated mORMot2 to today's commit, getting last 3 or 4 days of commits from repo.
Updated static libraries again to be sure.
Put "{$I mormot.defines.inc}" to every pas file.
I don't know which one is responsible, but for people who may encounter this error please try these steps first.
Thanks for your patience and support.
I know, anyway still believe this error belongs to my previous implementation. with a sample project, it works fine. I will implement my business login step by step and see where the issue is. will inform you when i found something useful.
When you write TRestServer(fOwner).fPublishedMethod, debug window return "Inaccessible value", that's why i use pointer to show you the difference between 2 computers.
New info, it seems it's related to windows version and/or regional settings.
Windows 11, Delphi 12.3, working.
Windows Server 2019 standard, Delphi 12.3, raises an error.

I know, there is nothing wrong with mORMot2, and tests passed successfully. Either way, at least i know where to look know and keep you guys informed. Thanks to you both..
I found the source of the problem. This occurs when i register my interface-based api. This is how i register my interfaces:
var i, j : Integer;
SFS: TServiceFactoryServer;
begin
SFS := TServiceFactoryServer(ServiceDefine(TAdmin, IAdmin, sicPerSession, SERVICE_CONTRACT_NONE_EXPECTED));
SFS.ResultAsJSONObjectWithoutResult := True;
SFS.SetOptions([], [optErrorOnMissingParam]);
end;Hi ab,
I tried setting root as 'app' but it's still the same. I am using Delphi 12.3, Version 29.0.55362.2017 and MongoDB 8 for database.
Ok, this happens with DEBUG build too. It works on my computer (surprise lol) which is win11, it raises same error with our server win2019 Server. I will test it with an empty sample and notify you. If anything comes up your mind, please share. Thanks.
koraycayiroglu wrote:made a pull request too
Thanks! I’ll review it this weekend. Is it based on the latest mORMot update?
Yes, it is.
If anyone still looking for JWT authentication and client usage, made a separate repo, added a win32 client and jwt client authentication classes.
https://github.com/koraycayiroglu/mormo … cation-jwt
kudos to flydev. (made a pull request too)
Hi everyone,
I just upgraded my services to mORMot2. Actually there isn't any problem with my services when i build them with DEBUG compiler directive. But when i make a release build, timestamp raises an EXCEPTION_ACCESS_VIOLATION inside TRestRouter.Lookup.

Any ideas?
What the Ukrainian people are going through is really sad, war is never a solution. Human beings need to overcome this, but unfortunately, selfish and self-interested people are always in administration. My prayers are with you and the Ukraine people too. I hope this stupid war will end soon.
Sorry, i thought AddOrUpdate means as it is and when i set ForceID to true, it will still add or update the same record with same ID. No problems, i changed it as:
function TSQLRest.AddOrUpdate(Value: TSQLRecord; ForceID: boolean): TID;
begin
if (self=nil) or (Value=nil) then begin
result := 0;
exit;
end;
if (Value.fID=0) or (ForceID and (not MemberExists(Value.RecordClass, Value.fID))) then begin
result := Add(Value,true,ForceID);
if (result<>0) or (Value.fID=0) then
exit;
end;
if Update(Value) then
result := Value.fID else
result := 0;
end;it's better this way imo.
Hi everyone,
It's not about mORMot2, but i am using latest version of mORMot and find a small bug imo.
function TSQLRest.AddOrUpdate(Value: TSQLRecord; ForceID: boolean): TID;
begin
if (self=nil) or (Value=nil) then begin
result := 0;
exit;
end;
if ForceID or (Value.fID=0) then begin // Add, raises an exception
result := Add(Value,true,ForceID);
if (result<>0) or (Value.fID=0) then
exit;
end;
if Update(Value) then
result := Value.fID else
result := 0;
end;When i set ForceID to True, AddOrUpdate raises an exception because it's uses OR. In this scenario even Value.fID is not 0 it still try to add this record. Isn't this suppose to be AND operator?
looks great! thanks for your hard work.
Confirming, problem solved when cross compiled from Win32 -> Linux X64
Thanks again for the tip!
Yes, thank you. This solved my problem too.
Best regards.
that's not what i meant, i used that example for simply pointing out there is a decimal symbol difference between two systems. Is there any function i should log in mormot? after these executed , there isn't anything for me to trace.
Hi again,
I try to figure out where the problem is but i am stocked. There isn't many differences between win and linux but here is my opinion.
First FloattoStr or any kind of conversion for double resulted:
For windows: Actual value 8.25 converted to 8,25
For linux: Actual value 8.25 converted to 8.25
there is a difference between decimal symbols and i think this creates the issue. I track TMongoRequest and it keeps original value 8.25 till the end. it either broke this value while using TMongoRequest.BSONWriteParam to create TMongoRequest or at TMongoConnection.Send(Request: TMongoRequest) while using Request.ToBSONDocument. After that there isn't anything besides fSocket.TrySndLow for sending data to server.
Actually, there is a os difference in fSocket.TrySndLow, which is:
{$ifdef MSWINDOWS}
if fSecure.Initialized then
sent := fSecure.Send(fSock, P, Len) else
{$endif MSWINDOWS}
sent := AsynchSend(fSock, P, Len);but i don't think this difference is related.
Conclusion: Linux converts double values to string or any kind using "." as decimal symbol, windows uses "," and somewhere between TMongoRequest.BSONWriteParam or TMongoConnection.Send(Request: TMongoRequest) while using Request.ToBSONDocument it converts to extended value because of decimal symbol.
Edit: Also json doc always contain DoubleVal with "." decimal symbol for both OS till the end. Exmaple: TMongoCollection.Insert Documents: {"DoubleVal":8.25,"_id":12}
hi Ab,
Sorry for making this post hang for a while, i was on a vacation. I did some tests today and want to ask a question:
here is my test log:
Test running...
Double Value: 8.25
Creating record...
Cheking record before insert...
Double values correct
mORMot - GetJSONValues: {"DoubleVal":8.25}
mORMot - TSQLRestStorageMongoDB.EngineAdd SentData: {"DoubleVal":8.25}
mORMot - TMongoRequest.BSONWriteParam paramDoc: {$query:{},$orderby:{_id:-1}}
mORMot - TMongoRequest.BSONWriteParam paramDoc: {_id:1}
mORMot - TSQLRestStorageMongoDB.EngineAdd DocFromJSON: {"DoubleVal":8.25,"_id":4}
mORMot - TMongoRequest.BSONWriteParam paramDoc: {"DoubleVal":8.25,"_id":4}
mORMot - TMongoRequest.BSONWriteParam paramDoc: getLastError
mORMot - TMongoRequest.BSONWriteParam paramDoc: {_id:4}
mORMot - TMongoRequest.BSONWriteParam paramDoc: {_id:1,DoubleVal:1}
Cheking record after insert...
ERROR: Double values
Double Value: 1.7678357372199011E-14
Test finished...For this case, when calling BSONWriteParam from SynMongoDB.TMongoRequest after first run as you can see paramdoc contains a getLastError value and at last run there is a record with _id:1 and doubleval:1 which i don't have.
Is this normal?
you should send files as rawbytestring. example:
// sample interfaced api code
TExampleApi = class(TInjectableObjectRest, IExampleApi)
public
procedure uploadfile(const rawfile: RawByteString);
end;
implementation
procedure TExampleApi.sendfile(const rawfile: RawByteString);
begin
FileFromString(base64toBin(rawfile), FilePath, true, FileDate);
end;
// sample usage
Apclient.ExampleApi.sendFile(BinToBase64(StringFromFile("C:\examplefile.png")));Current goal is to have finished the mORMot2 port for Ekon conference - https://entwickler-konferenz.de/delphi- … s/mormot2/
Is it gonna have online broadcast?
of course, i will do my best to find out the problem but i will do it when i have time.
best regards
I did try mongo shell see if any problems in configuration. there isnt.
> db
test24
> db.mORMot.insertOne( { "_id": "100", "Name": "console test", "Age": "38", "Date": ISODate("1982-07-17T00:00:00.000Z"), "Value": { "num": 39 }, "Ints": [38], "CreateTime": NumberLong(135592835140), "FP": 8.38 } )
{ "acknowledged" : true, "insertedId" : "100" }inserted document
{
"_id" : "100",
"Name" : "console test",
"Age" : "38",
"Date" : ISODate("1982-07-17T00:00:00.000Z"),
"Value" : {
"num" : 39.0
},
"Ints" : [
38.0
],
"CreateTime" : NumberLong(135592835140),
"FP" : 8.38
}My server up to date, mongo up to date, lazarus+fpx cross compiler up to date and same revision numbers.
My code works from every where except linux.
I did upgrade my ubuntu server to match yours, it's still same.
koray@ubuntu-vm:~$ ./MongoDBTests
Mongo DB
----------
1. Direct access
1.1. Direct with acknowledge:
- Connect to local server: 6 assertions passed 57.99ms
- Drop and prepare collection: 7 assertions passed 13.46ms
- Fill collection: 353 assertions passed 74.40ms
100 rows inserted in 73.35ms i.e. 1,363/s, aver. 733us, 489.8 KB/s
- Drop collection: no assertion 5.52ms
- Fill collection bulk: 2 assertions passed 44.19ms
100 rows inserted in 43.68ms i.e. 2,289/s, aver. 436us, 216.8 KB/s
- Graceful reconnect: 3 assertions passed 24.24ms
- Read collection: 603 assertions passed 93.46ms
100 rows read at once in 1.32ms i.e. 75,471/s, aver. 13us, 5.6 MB/s
- Update collection: 136 assertions passed 34.21ms
100 rows updated in 19.23ms i.e. 5,199/s, aver. 192us, 1.6 MB/s
- Delete some items: 82 assertions passed 13.86ms
20 rows deleted in 4.96ms i.e. 4,031/s, aver. 248us, 917.3 KB/s
Total failed: 0 / 1,192 - Direct with acknowledge PASSED 361.64ms
1.2. Direct without acknowledge:
- Connect to local server: 6 assertions passed 22.66ms
- Drop and prepare collection: 7 assertions passed 8.93ms
- Fill collection: 353 assertions passed 59.94ms
100 rows inserted in 51.44ms i.e. 1,943/s, aver. 514us, 294 KB/s
- Drop collection: no assertion 8.02ms
- Fill collection bulk: 2 assertions passed 43.03ms
100 rows inserted in 42.67ms i.e. 2,343/s, aver. 426us, 218 KB/s
- Graceful reconnect: 3 assertions passed 23.78ms
- Read collection: 603 assertions passed 80.72ms
100 rows read at once in 1.61ms i.e. 62,111/s, aver. 16us, 4.6 MB/s
- Update collection: 136 assertions passed 21.92ms
100 rows updated in 7.29ms i.e. 13,700/s, aver. 72us, 1.7 MB/s
- Delete some items: 82 assertions passed 12.06ms
20 rows deleted in 687us i.e. 29,112/s, aver. 34us, 1.6 MB/s
Total failed: 0 / 1,192 - Direct without acknowledge PASSED 281.37ms
2. ORM
2.1. ORM with acknowledge:
- Connect to local server: 6 assertions passed 32.82ms
- Insert: 102 assertions passed 50.78ms
100 rows inserted in 44.55ms i.e. 2,244/s, aver. 445us, 723.8 KB/s
- Insert in batch mode: 104 assertions passed 29.94ms
100 rows inserted in 29.54ms i.e. 3,384/s, aver. 295us, 427.4 KB/s
#11 1.5738023723650378E-14<>7.3445 #21 3.1476047447300757E-14<>14.689 #31 4.7214071170951138E-14<>22.0335 #41 6.2952094894601513E-14<>29.378 #51 7.8690118618251895E-14<>36.7225 #61 9.4428142341902276E-14<>44.067 #71 1.1016616606555263E-13<>51.4115 #81 1.2590418978920303E-13<>58.756 #91 1.4164221351285338E-13<>66.1005 #101 1.5738023723650374E-13<>73.445 #111 1.7311826096015412E-13<>80.7895 #121 1.888562846838045E-13<>88.134 #131 2.0459430840745491E-13<>95.4785 #141 2.2033233213110526E-13<>102.823 #151 2.3607035585475567E-13<>110.1675 #161 2.51808379578406E-13<>117.512 #171 2.6754640330205643E-13<>124.8565 #181 2.8328442702570676E-13<>132.201 #191 2.9902245074935715E-13<>139.5455 #201 3.1476047447300748E-13<>146.89 #211 3.3049849819665791E-13<>154.2345 #221 3.4623652192030824E-13<>161.579 #231 3.6197454564395862E-13<>168.9235 #241 3.77712569367609E-13<>176.268 #251 3.9345059309125944E-13<>183.6125 #261 4.0918861681490982E-13<>190.957 #271 4.249266405385602E-13<>198.3015 #281 4.4066466426221053E-13<>205.646 #291 4.5640268798586096E-13<>212.9905 #301 4.7214071170951134E-13<>220.335 #311 4.8787873543316172E-13<>227.6795 #321 5.03616759156812E-13<>235.024 #331 5.1935478288046249E-13<>242.3685 #341 5.3509280660411287E-13<>249.713 #351 5.5083083032776305E-13<>257.0575 #361 5.6656885405141353E-13<>264.402 #371 5.8230687777506391E-13<>271.7465
#381 5.9804490149871429E-13<>279.091 #391 6.1378292522236457E-13<>286.4355 #401 6.2952094894601496E-13<>293.78 #411 6.4525897266966544E-13<>301.1245 #421 6.6099699639331582E-13<>308.469 #431 6.767350201169662E-13<>315.8135 #441 6.9247304384061648E-13<>323.158 #451 7.0821106756426696E-13<>330.5025 #461 7.2394909128791724E-13<>337.847 #471 7.3968711501156763E-13<>345.1915 #481 7.5542513873521801E-13<>352.536 #491 7.7116316245886839E-13<>359.8805 #501 7.8690118618251887E-13<>367.225 #511 8.0263920990616925E-13<>374.5695 #521 8.1837723362981963E-13<>381.914 #531 8.3411525735347002E-13<>389.2585 #541 8.498532810771204E-13<>396.603 #551 8.6559130480077068E-13<>403.9475 #561 8.8132932852442106E-13<>411.292 #571 8.9706735224807144E-13<>418.6365 #581 9.1280537597172192E-13<>425.981 #591 9.285433996953723E-13<>433.3255 #601 9.4428142341902269E-13<>440.67 #611 9.6001944714267307E-13<>448.0145 #621 9.7575747086632345E-13<>455.359 #631 9.9149549458997363E-13<>462.7035 #641 1.0072335183136242E-12<>470.048 #651 1.0229715420372746E-12<>477.3925 #661 1.038709565760925E-12<>484.737 #671 1.0544475894845754E-12<>492.0815 #681 1.0701856132082255E-12<>499.426 #691 1.0859236369318759E-12<>506.7705 #701 1.1016616606555263E-12<>514.115 #711 1.1173996843791767E-12<>521.4595 #721 1.1331377081028273E-12<>528.804 #731 1.1488757318264774E-12<>536.1485 #741 1.1646137555501278E-12<>543.493 #751 1.1803517792737782E-12<>550.8375 #761 1.1960898029974286E-12<>558.182 #771 1.211827826721079E-12<>565.5265 #781 1.2275658504447294E-12<>572.871 #791 1.2433038741683795E-12<>580.2155 #801 1.2590418978920299E-12<>587.56 #811 1.2747799216156803E-12<>594.9045 #821 1.2905179453393307E-12<>602.249 #831 1.3062559690629812E-12<>609.5935 #841 1.3219939927866316E-12<>616.938 #851 1.337732016510282E-12<>624.2825 #861 1.3534700402339324E-12<>631.627 #871 1.3692080639575828E-12<>638.9715 #881 1.3849460876812332E-12<>646.316 #891 1.4006841114048835E-12<>653.6605 #901 1.4164221351285339E-12<>661.005 #911 1.4321601588521843E-12<>668.3495 #921 1.4478981825758347E-12<>675.694 #931 1.4636362062994851E-12<>683.0385 #941 1.4793742300231354E-12<>690.383 #951 1.4951122537467858E-12<>697.7275 #961 1.5108502774704362E-12<>705.072 #971 1.5265883011940866E-12<>712.4165 #981 1.542326324917737E-12<>719.761 #991 1.5580643486413874E-12<>727.1055 #1001 1.5738023723650375E-12<>734.45 ! - Retrieve: 100 / 1,001 FAILED 30.26ms
100 rows retrieved in 30.24ms i.e. 3,306/s, aver. 302us, 0.9 MB/s
#9 1.5738023723650378E-14<>7.3445 #18 3.1476047447300757E-14<>14.689 #27 4.7214071170951138E-14<>22.0335 #36 6.2952094894601513E-14<>29.378 #45 7.8690118618251895E-14<>36.7225 #54 9.4428142341902276E-14<>44.067 #63 1.1016616606555263E-13<>51.4115 #72 1.2590418978920303E-13<>58.756 #81 1.4164221351285338E-13<>66.1005 #90 1.5738023723650374E-13<>73.445 #99 1.7311826096015412E-13<>80.7895 #108 1.888562846838045E-13<>88.134 #117 2.0459430840745491E-13<>95.4785 #126 2.2033233213110526E-13<>102.823 #135 2.3607035585475567E-13<>110.1675 #144 2.51808379578406E-13<>117.512 #153 2.6754640330205643E-13<>124.8565 #162 2.8328442702570676E-13<>132.201 #171 2.9902245074935715E-13<>139.5455 #180 3.1476047447300748E-13<>146.89 #189 3.3049849819665791E-13<>154.2345 #198 3.4623652192030824E-13<>161.579 #207 3.6197454564395862E-13<>168.9235 #216 3.77712569367609E-13<>176.268 #225 3.9345059309125944E-13<>183.6125 #234 4.0918861681490982E-13<>190.957 #243 4.249266405385602E-13<>198.3015 #252 4.4066466426221053E-13<>205.646 #261 4.5640268798586096E-13<>212.9905 #270 4.7214071170951134E-13<>220.335 #279 4.8787873543316172E-13<>227.6795
#288 5.03616759156812E-13<>235.024 #297 5.1935478288046249E-13<>242.3685 #306 5.3509280660411287E-13<>249.713 #315 5.5083083032776305E-13<>257.0575 #324 5.6656885405141353E-13<>264.402 #333 5.8230687777506391E-13<>271.7465 #342 5.9804490149871429E-13<>279.091 #351 6.1378292522236457E-13<>286.4355 #360 6.2952094894601496E-13<>293.78 #369 6.4525897266966544E-13<>301.1245 #378 6.6099699639331582E-13<>308.469 #387 6.767350201169662E-13<>315.8135 #396 6.9247304384061648E-13<>323.158 #405 7.0821106756426696E-13<>330.5025 #414 7.2394909128791724E-13<>337.847 #423 7.3968711501156763E-13<>345.1915 #432 7.5542513873521801E-13<>352.536 #441 7.7116316245886839E-13<>359.8805 #450 7.8690118618251887E-13<>367.225 #459 8.0263920990616925E-13<>374.5695 #468 8.1837723362981963E-13<>381.914 #477 8.3411525735347002E-13<>389.2585 #486 8.498532810771204E-13<>396.603 #495 8.6559130480077068E-13<>403.9475 #504 8.8132932852442106E-13<>411.292 #513 8.9706735224807144E-13<>418.6365 #522 9.1280537597172192E-13<>425.981 #531 9.285433996953723E-13<>433.3255 #540 9.4428142341902269E-13<>440.67 #549 9.6001944714267307E-13<>448.0145 #558 9.7575747086632345E-13<>455.359 #567 9.9149549458997363E-13<>462.7035 #576 1.0072335183136242E-12<>470.048 #585 1.0229715420372746E-12<>477.3925 #594 1.038709565760925E-12<>484.737 #603 1.0544475894845754E-12<>492.0815 #612 1.0701856132082255E-12<>499.426 #621 1.0859236369318759E-12<>506.7705 #630 1.1016616606555263E-12<>514.115 #639 1.1173996843791767E-12<>521.4595 #648 1.1331377081028273E-12<>528.804 #657 1.1488757318264774E-12<>536.1485 #666 1.1646137555501278E-12<>543.493 #675 1.1803517792737782E-12<>550.8375 #684 1.1960898029974286E-12<>558.182 #693 1.211827826721079E-12<>565.5265 #702 1.2275658504447294E-12<>572.871 #711 1.2433038741683795E-12<>580.2155 #720 1.2590418978920299E-12<>587.56 #729 1.2747799216156803E-12<>594.9045 #738 1.2905179453393307E-12<>602.249 #747 1.3062559690629812E-12<>609.5935 #756 1.3219939927866316E-12<>616.938 #765 1.337732016510282E-12<>624.2825 #774 1.3534700402339324E-12<>631.627 #783 1.3692080639575828E-12<>638.9715 #792 1.3849460876812332E-12<>646.316 #801 1.4006841114048835E-12<>653.6605 #810 1.4164221351285339E-12<>661.005 #819 1.4321601588521843E-12<>668.3495 #828 1.4478981825758347E-12<>675.694 #837 1.4636362062994851E-12<>683.0385 #846 1.4793742300231354E-12<>690.383 #855 1.4951122537467858E-12<>697.7275 #864 1.5108502774704362E-12<>705.072 #873 1.5265883011940866E-12<>712.4165 #882 1.542326324917737E-12<>719.761 #891 1.5580643486413874E-12<>727.1055 #900 1.5738023723650375E-12<>734.45 ! - Retrieve all: 100 / 901 FAILED 2.44ms
100 rows retrieved in 2.43ms i.e. 41,152/s, aver. 24us, 5 MB/s
#9 1.5738023723650378E-14<>7.3445 #19 3.1476047447300757E-14<>14.689 #29 4.7214071170951138E-14<>22.0335 #39 6.2952094894601513E-14<>29.378 #49 7.8690118618251895E-14<>36.7225 #59 9.4428142341902276E-14<>44.067 #69 1.1016616606555263E-13<>51.4115 #79 1.2590418978920303E-13<>58.756 #89 1.4164221351285338E-13<>66.1005 #99 1.5738023723650374E-13<>73.445 #109 1.7311826096015412E-13<>80.7895 #119 1.888562846838045E-13<>88.134 #129 2.0459430840745491E-13<>95.4785 #139 2.2033233213110526E-13<>102.823 #149 2.3607035585475567E-13<>110.1675 #159 2.51808379578406E-13<>117.512 #169 2.6754640330205643E-13<>124.8565 #179 2.8328442702570676E-13<>132.201 #189 2.9902245074935715E-13<>139.5455 #199 3.1476047447300748E-13<>146.89 #209 3.3049849819665791E-13<>154.2345 #219 3.4623652192030824E-13<>161.579 #229 3.6197454564395862E-13<>168.9235 #239 3.77712569367609E-13<>176.268 #249 3.9345059309125944E-13<>183.6125 #259 4.0918861681490982E-13<>190.957 #269 4.249266405385602E-13<>198.3015 #279 4.4066466426221053E-13<>205.646 #289 4.5640268798586096E-13<>212.9905 #299 4.7214071170951134E-13<>220.335 #309 4.8787873543316172E-13<>227.6795
#319 5.03616759156812E-13<>235.024 #329 5.1935478288046249E-13<>242.3685 #339 5.3509280660411287E-13<>249.713 #349 5.5083083032776305E-13<>257.0575 #359 5.6656885405141353E-13<>264.402 #369 5.8230687777506391E-13<>271.7465
#379 5.9804490149871429E-13<>279.091 #389 6.1378292522236457E-13<>286.4355 #399 6.2952094894601496E-13<>293.78 #409 6.4525897266966544E-13<>301.1245 #419 6.6099699639331582E-13<>308.469 #429 6.767350201169662E-13<>315.8135 #439 6.9247304384061648E-13<>323.158 #449 7.0821106756426696E-13<>330.5025 #459 7.2394909128791724E-13<>337.847 #469 7.3968711501156763E-13<>345.1915 #479 7.5542513873521801E-13<>352.536 #489 7.7116316245886839E-13<>359.8805 #499 7.8690118618251887E-13<>367.225 #509 8.0263920990616925E-13<>374.5695 #519 8.1837723362981963E-13<>381.914 #529 8.3411525735347002E-13<>389.2585 #539 8.498532810771204E-13<>396.603 #549 8.6559130480077068E-13<>403.9475 #559 8.8132932852442106E-13<>411.292 #569 8.9706735224807144E-13<>418.6365 #579 9.1280537597172192E-13<>425.981 #589 9.285433996953723E-13<>433.3255 #599 9.4428142341902269E-13<>440.67 #609 9.6001944714267307E-13<>448.0145 #619 9.7575747086632345E-13<>455.359 #629 9.9149549458997363E-13<>462.7035 #639 1.0072335183136242E-12<>470.048 #649 1.0229715420372746E-12<>477.3925 #659 1.038709565760925E-12<>484.737 #669 1.0544475894845754E-12<>492.0815 #679 1.0701856132082255E-12<>499.426 #689 1.0859236369318759E-12<>506.7705 #699 1.1016616606555263E-12<>514.115 #709 1.1173996843791767E-12<>521.4595 #719 1.1331377081028273E-12<>528.804 #729 1.1488757318264774E-12<>536.1485 #739 1.1646137555501278E-12<>543.493 #749 1.1803517792737782E-12<>550.8375 #759 1.1960898029974286E-12<>558.182 #769 1.211827826721079E-12<>565.5265 #779 1.2275658504447294E-12<>572.871 #789 1.2433038741683795E-12<>580.2155 #799 1.2590418978920299E-12<>587.56 #809 1.2747799216156803E-12<>594.9045 #819 1.2905179453393307E-12<>602.249 #829 1.3062559690629812E-12<>609.5935 #839 1.3219939927866316E-12<>616.938 #849 1.337732016510282E-12<>624.2825 #859 1.3534700402339324E-12<>631.627 #869 1.3692080639575828E-12<>638.9715 #879 1.3849460876812332E-12<>646.316 #889 1.4006841114048835E-12<>653.6605 #899 1.4164221351285339E-12<>661.005 #909 1.4321601588521843E-12<>668.3495 #919 1.4478981825758347E-12<>675.694 #929 1.4636362062994851E-12<>683.0385 #939 1.4793742300231354E-12<>690.383 #949 1.4951122537467858E-12<>697.7275 #959 1.5108502774704362E-12<>705.072 #969 1.5265883011940866E-12<>712.4165 #979 1.542326324917737E-12<>719.761 #989 1.5580643486413874E-12<>727.1055 #999 1.5738023723650375E-12<>734.45 ! - Retrieve one with where clause: 100 / 1,000 FAILED 24.84ms
100 rows retrieved in 24.83ms i.e. 4,026/s, aver. 248us, 1.1 MB/s
#9 6.767350201169662E-13<>315.8135 #19 1.5738023723650378E-14<>7.3445 #29 3.1476047447300757E-14<>14.689 #39 4.7214071170951138E-14<>22.0335 #49 6.2952094894601513E-14<>29.378 #59 7.8690118618251895E-14<>36.7225 #69 9.4428142341902276E-14<>44.067 #79 1.1016616606555263E-13<>51.4115 #89 1.2590418978920303E-13<>58.756 #99 1.4164221351285338E-13<>66.1005 #109 1.5738023723650374E-13<>73.445 #119 1.7311826096015412E-13<>80.7895 #129 1.888562846838045E-13<>88.134 #139 2.0459430840745491E-13<>95.4785 #149 2.2033233213110526E-13<>102.823 #159 2.3607035585475567E-13<>110.1675 #169 2.51808379578406E-13<>117.512 #179 2.6754640330205643E-13<>124.8565 #189 2.8328442702570676E-13<>132.201 #199 2.9902245074935715E-13<>139.5455 #209 3.1476047447300748E-13<>146.89 #219 3.3049849819665791E-13<>154.2345 #229 3.4623652192030824E-13<>161.579 #239 3.6197454564395862E-13<>168.9235 #249 3.77712569367609E-13<>176.268 #259 3.9345059309125944E-13<>183.6125 #269 4.0918861681490982E-13<>190.957 #279 4.249266405385602E-13<>198.3015 #289 4.4066466426221053E-13<>205.646 #299 4.5640268798586096E-13<>212.9905 #309 4.7214071170951134E-13<>220.335
#319 4.8787873543316172E-13<>227.6795 #329 5.03616759156812E-13<>235.024 #339 5.1935478288046249E-13<>242.3685 #349 5.3509280660411287E-13<>249.713 #359 5.5083083032776305E-13<>257.0575 #369 5.6656885405141353E-13<>264.402 #379 5.8230687777506391E-13<>271.7465 #389 5.9804490149871429E-13<>279.091 #399 6.1378292522236457E-13<>286.4355 #409 6.2952094894601496E-13<>293.78 #419 6.4525897266966544E-13<>301.1245 #429 6.6099699639331582E-13<>308.469 #439 6.767350201169662E-13<>315.8135 #449 6.9247304384061648E-13<>323.158 #459 7.0821106756426696E-13<>330.5025 #469 7.2394909128791724E-13<>337.847 #479 7.3968711501156763E-13<>345.1915 #489 7.5542513873521801E-13<>352.536 #499 7.7116316245886839E-13<>359.8805 #509 7.8690118618251887E-13<>367.225 #519 1.0072335183136242E-12<>470.048 #529 1.0229715420372746E-12<>477.3925 #539 1.038709565760925E-12<>484.737 #549 1.0544475894845754E-12<>492.0815 #559 1.0701856132082255E-12<>499.426 #569 1.0859236369318759E-12<>506.7705 #579 1.1016616606555263E-12<>514.115 #589 1.1173996843791767E-12<>521.4595 #599 1.1331377081028273E-12<>528.804 #609 1.1488757318264774E-12<>536.1485 #619 1.1646137555501278E-12<>543.493 #629 1.1803517792737782E-12<>550.8375 #639 1.1960898029974286E-12<>558.182 #649 1.211827826721079E-12<>565.5265 #659 1.2275658504447294E-12<>572.871 #669 1.2433038741683795E-12<>580.2155 #679 1.2590418978920299E-12<>587.56 #689 1.2747799216156803E-12<>594.9045 #699 1.2905179453393307E-12<>602.249 #709 1.3062559690629812E-12<>609.5935 #719 1.3219939927866316E-12<>616.938 #729 1.337732016510282E-12<>624.2825 #739 1.3534700402339324E-12<>631.627 #749 1.3692080639575828E-12<>638.9715 #759 1.3849460876812332E-12<>646.316 #769 1.4006841114048835E-12<>653.6605 #779 1.4164221351285339E-12<>661.005 #789 1.4321601588521843E-12<>668.3495 #799 1.4478981825758347E-12<>675.694 #809 1.4636362062994851E-12<>683.0385 #819 1.4793742300231354E-12<>690.383 #829 1.4951122537467858E-12<>697.7275 #839 1.5108502774704362E-12<>705.072 #849 1.5265883011940866E-12<>712.4165 #859 1.542326324917737E-12<>719.761 #869 1.5580643486413874E-12<>727.1055 #879 1.5738023723650375E-12<>734.45 #890 1.5738023723650378E-14<>7.3445 #900 3.1476047447300757E-14<>14.689 #910 4.7214071170951138E-14<>22.0335 #920 6.2952094894601513E-14<>29.378 #930 7.8690118618251895E-14<>36.7225 #940 9.4428142341902276E-14<>44.067 #950 1.1016616606555263E-13<>51.4115 #960 1.2590418978920303E-13<>58.756 #970 1.4164221351285338E-13<>66.1005 #980 1.5738023723650374E-13<>73.445 #990 1.7311826096015412E-13<>80.7895 #1000 1.888562846838045E-13<>88.134 #1010 2.0459430840745491E-13<>95.4785 #1020 2.2033233213110526E-13<>102.823 #1030 2.3607035585475567E-13<>110.1675 #1040 2.51808379578406E-13<>117.512 #1050 2.6754640330205643E-13<>124.8565 #1060 2.8328442702570676E-13<>132.201 #1070 2.9902245074935715E-13<>139.5455 #1080 3.1476047447300748E-13<>146.89 #1090 3.3049849819665791E-13<>154.2345 #1100 3.4623652192030824E-13<>161.579 #1110 3.6197454564395862E-13<>168.9235 #1120 3.77712569367609E-13<>176.268 #1130 3.9345059309125944E-13<>183.6125 #1140 4.0918861681490982E-13<>190.957 #1150 4.249266405385602E-13<>198.3015 #1160 4.4066466426221053E-13<>205.646 #1170 4.5640268798586096E-13<>212.9905 #1180 4.7214071170951134E-13<>220.335 #1190 4.8787873543316172E-13<>227.6795 #1200 5.03616759156812E-13<>235.024 #1210 5.1935478288046249E-13<>242.3685 #1220 5.3509280660411287E-13<>249.713 #1230 5.5083083032776305E-13<>257.0575 #1240 5.6656885405141353E-13<>264.402 #1250 5.8230687777506391E-13<>271.7465 #1260 5.9804490149871429E-13<>279.091 #1270 6.1378292522236457E-13<>286.4355 #1280 6.2952094894601496E-13<>293.78 #1290 6.4525897266966544E-13<>301.1245 #1300 6.6099699639331582E-13<>308.469 #1310 6.767350201169662E-13<>315.8135 #1320 6.9247304384061648E-13<>323.158 #1330 7.0821106756426696E-13<>330.5025 #1340 7.2394909128791724E-13<>337.847 #1350 7.3968711501156763E-13<>345.1915 #1360 7.5542513873521801E-13<>352.536 #1370 7.7116316245886839E-13<>359.8805 #1380 8.0263920990616925E-13<>374.5695 #1390 8.1837723362981963E-13<>381.914 #1400 8.3411525735347002E-13<>389.2585 #1410 8.498532810771204E-13<>396.603 #1420 8.6559130480077068E-13<>403.9475 #1430 8.8132932852442106E-13<>411.292 #1440 8.9706735224807144E-13<>418.6365 #1450 9.1280537597172192E-13<>425.981 #1460 9.285433996953723E-13<>433.3255 #1470 9.4428142341902269E-13<>440.67 #1480 9.6001944714267307E-13<>448.0145 #1490 9.7575747086632345E-13<>455.359 #1500 9.9149549458997363E-13<>462.7035 #1510 1.0072335183136242E-12<>470.048 #1520 1.0229715420372746E-12<>477.3925 #1530 1.038709565760925E-12<>484.737 #1540 1.0544475894845754E-12<>492.0815 #1550 1.0701856132082255E-12<>499.426 #1560 1.0859236369318759E-12<>506.7705 #1570 1.1016616606555263E-12<>514.115
#1580 1.1173996843791767E-12<>521.4595 #1590 1.1331377081028273E-12<>528.804 #1600 1.1488757318264774E-12<>536.1485 #1610 1.1646137555501278E-12<>543.493 #1620 1.1803517792737782E-12<>550.8375 #1630 1.1960898029974286E-12<>558.182 #1640 1.211827826721079E-12<>565.5265 #1650 1.2275658504447294E-12<>572.871 #1660 1.2433038741683795E-12<>580.2155 #1670 1.2590418978920299E-12<>587.56 #1680 1.2747799216156803E-12<>594.9045 #1690 1.2905179453393307E-12<>602.249 #1700 1.3062559690629812E-12<>609.5935 #1710 1.3219939927866316E-12<>616.938 #1720 1.337732016510282E-12<>624.2825 #1730 1.3534700402339324E-12<>631.627 #1740 1.3692080639575828E-12<>638.9715 #1750 1.3849460876812332E-12<>646.316 #1760 1.4006841114048835E-12<>653.6605 #1770 1.4164221351285339E-12<>661.005 #1780 1.4321601588521843E-12<>668.3495 #1790 1.4478981825758347E-12<>675.694 #1800 1.4636362062994851E-12<>683.0385 #1810 1.4793742300231354E-12<>690.383 #1820 1.4951122537467858E-12<>697.7275 #1830 1.5108502774704362E-12<>705.072 #1840 1.5265883011940866E-12<>712.4165 #1850 1.542326324917737E-12<>719.761 #1860 1.5580643486413874E-12<>727.1055 #1870 1.5738023723650375E-12<>734.45 #1881 8.1837723362981963E-13<>381.914 #1891 8.3411525735347002E-13<>389.2585 #1901 8.498532810771204E-13<>396.603 #1911 8.6559130480077068E-13<>403.9475 #1921 8.8132932852442106E-13<>411.292 #1931 8.9706735224807144E-13<>418.6365 #1941 9.1280537597172192E-13<>425.981 #1951 9.285433996953723E-13<>433.3255 #1961 9.4428142341902269E-13<>440.67 #1971 9.6001944714267307E-13<>448.0145 #1981 9.7575747086632345E-13<>455.359 #1991 9.9149549458997363E-13<>462.7035 #2002 1.5738023723650378E-14<>7.3445 #2011 3.1476047447300757E-14<>14.689 #2020 4.7214071170951138E-14<>22.0335 #2029 6.2952094894601513E-14<>29.378 #2038 7.8690118618251895E-14<>36.7225 #2047 9.4428142341902276E-14<>44.067 #2056 1.1016616606555263E-13<>51.4115 #2065 1.2590418978920303E-13<>58.756 #2074 1.4164221351285338E-13<>66.1005 #2083 1.5738023723650374E-13<>73.445 #2093 1.7311826096015412E-13<>80.7895 #2102 1.888562846838045E-13<>88.134 #2111 2.0459430840745491E-13<>95.4785 #2120 2.2033233213110526E-13<>102.823 #2129 2.3607035585475567E-13<>110.1675 #2138 2.51808379578406E-13<>117.512 #2147 2.6754640330205643E-13<>124.8565 #2156 2.8328442702570676E-13<>132.201 #2165 2.9902245074935715E-13<>139.5455 #2174 3.1476047447300748E-13<>146.89 #2184 1.5738023723650378E-14<>7.3445 #2193 1.5738023723650374E-13<>73.445 #2203 1.5738023723650375E-12<>734.45 #2213 1.7311826096015412E-13<>80.7895 #2223 1.888562846838045E-13<>88.134 #2233 2.0459430840745491E-13<>95.4785 #2243 2.2033233213110526E-13<>102.823 #2253 2.3607035585475567E-13<>110.1675 #2263 2.51808379578406E-13<>117.512 #2273 2.6754640330205643E-13<>124.8565 #2283 2.8328442702570676E-13<>132.201 #2293 2.9902245074935715E-13<>139.5455 #2303 3.1476047447300757E-14<>14.689 #2313 3.1476047447300748E-13<>146.89 #2323 3.3049849819665791E-13<>154.2345 #2333 3.4623652192030824E-13<>161.579 #2343 3.6197454564395862E-13<>168.9235 #2353 3.77712569367609E-13<>176.268 #2363 3.9345059309125944E-13<>183.6125 #2373 4.0918861681490982E-13<>190.957 #2383 4.249266405385602E-13<>198.3015 #2393 4.4066466426221053E-13<>205.646 #2403 4.5640268798586096E-13<>212.9905 #2413 4.7214071170951138E-14<>22.0335 #2423 4.7214071170951134E-13<>220.335 #2433 4.8787873543316172E-13<>227.6795 #2443 5.03616759156812E-13<>235.024 #2453 5.1935478288046249E-13<>242.3685 #2463 5.3509280660411287E-13<>249.713 #2473 5.5083083032776305E-13<>257.0575 #2483 5.6656885405141353E-13<>264.402 #2493 5.8230687777506391E-13<>271.7465 #2503 5.9804490149871429E-13<>279.091 #2513 6.1378292522236457E-13<>286.4355 #2523 6.2952094894601513E-14<>29.378 #2533 6.2952094894601496E-13<>293.78 #2543 6.4525897266966544E-13<>301.1245 #2553 6.6099699639331582E-13<>308.469 #2563 6.767350201169662E-13<>315.8135 #2573 6.9247304384061648E-13<>323.158 #2583 7.0821106756426696E-13<>330.5025 #2593 7.2394909128791724E-13<>337.847 #2603 7.3968711501156763E-13<>345.1915 #2613 7.5542513873521801E-13<>352.536 #2623 7.7116316245886839E-13<>359.8805
#2633 7.8690118618251895E-14<>36.7225 #2643 7.8690118618251887E-13<>367.225 #2653 8.0263920990616925E-13<>374.5695 #2663 8.1837723362981963E-13<>381.914 #2673 8.3411525735347002E-13<>389.2585 #2683 8.498532810771204E-13<>396.603 #2693 8.6559130480077068E-13<>403.9475 #2703 8.8132932852442106E-13<>411.292 #2713 8.9706735224807144E-13<>418.6365 #2723 9.1280537597172192E-13<>425.981 #2733 9.285433996953723E-13<>433.3255 #2743 9.4428142341902276E-14<>44.067 #2753 9.4428142341902269E-13<>440.67 #2763 9.6001944714267307E-13<>448.0145 #2773 9.7575747086632345E-13<>455.359 #2783 9.9149549458997363E-13<>462.7035 #2793 1.0072335183136242E-12<>470.048 #2803 1.0229715420372746E-12<>477.3925 #2813 1.038709565760925E-12<>484.737 #2823 1.0544475894845754E-12<>492.0815 #2833 1.0701856132082255E-12<>499.426 #2843 1.0859236369318759E-12<>506.7705 #2853 1.1016616606555263E-13<>51.4115 #2863 1.1016616606555263E-12<>514.115 #2873 1.1173996843791767E-12<>521.4595 #2883 1.1331377081028273E-12<>528.804 #2893 1.1488757318264774E-12<>536.1485 #2903 1.1646137555501278E-12<>543.493 #2913 1.1803517792737782E-12<>550.8375 #2923 1.1960898029974286E-12<>558.182 #2933 1.211827826721079E-12<>565.5265 #2943 1.2275658504447294E-12<>572.871 #2953 1.2433038741683795E-12<>580.2155 #2963 1.2590418978920303E-13<>58.756 #2973 1.2590418978920299E-12<>587.56 #2983 1.2747799216156803E-12<>594.9045 #2993 1.2905179453393307E-12<>602.249 #3003 1.3062559690629812E-12<>609.5935 #3013 1.3219939927866316E-12<>616.938 #3023 1.337732016510282E-12<>624.2825 #3033 1.3534700402339324E-12<>631.627 #3043 1.3692080639575828E-12<>638.9715 #3053 1.3849460876812332E-12<>646.316 #3063 1.4006841114048835E-12<>653.6605 #3073 1.4164221351285338E-13<>66.1005 #3083 1.4164221351285339E-12<>661.005 #3093 1.4321601588521843E-12<>668.3495 #3103 1.4478981825758347E-12<>675.694 #3113 1.4636362062994851E-12<>683.0385 #3123 1.4793742300231354E-12<>690.383 #3133 1.4951122537467858E-12<>697.7275 #3143 1.5108502774704362E-12<>705.072 #3153 1.5265883011940866E-12<>712.4165 #3163 1.542326324917737E-12<>719.761 #3173 1.5580643486413874E-12<>727.1055 #3185 1.5738023723650378E-14<>7.3445 #3195 1.5738023723650374E-13<>73.445 #3205 3.1476047447300748E-13<>146.89 #3215 1.0229715420372746E-12<>477.3925 #3225 1.1646137555501278E-12<>543.493 #3235 1.3219939927866316E-12<>616.938 #3246 1.5738023723650374E-13<>73.445 #3256 1.5738023723650374E-13<>73.445 #3266 3.1476047447300748E-13<>146.89 #3276 4.7214071170951134E-13<>220.335 #3286 1.1646137555501278E-12<>543.493 #3296 1.3219939927866316E-12<>616.938 #3307 1.3219939927866316E-12<>616.938 #3317 1.1646137555501278E-12<>543.493 #3327 6.2952094894601496E-13<>293.78 #3337 3.1476047447300748E-13<>146.89 #3347 1.5738023723650374E-13<>73.445 #3359 1.5738023723650378E-14<>7.3445 #3369 1.5738023723650374E-13<>73.445 #3379 1.7311826096015412E-13<>80.7895 #3389 1.888562846838045E-13<>88.134 #3399 2.0459430840745491E-13<>95.4785 #3409 2.2033233213110526E-13<>102.823 #3419 2.3607035585475567E-13<>110.1675 #3429 2.51808379578406E-13<>117.512 #3439 2.6754640330205643E-13<>124.8565 #3449 2.8328442702570676E-13<>132.201 #3459 2.9902245074935715E-13<>139.5455 #3469 1.5738023723650375E-12<>734.45 #3480 1.5738023723650378E-14<>7.3445 #3491 1.5738023723650378E-14<>7.3445 #3501 1.5738023723650374E-13<>73.445 #3511 1.7311826096015412E-13<>80.7895 #3521 1.888562846838045E-13<>88.134 #3531 2.0459430840745491E-13<>95.4785 #3541 2.2033233213110526E-13<>102.823 #3551 2.3607035585475567E-13<>110.1675 #3561 2.51808379578406E-13<>117.512 #3571 2.6754640330205643E-13<>124.8565 #3581 2.8328442702570676E-13<>132.201 #3591 2.9902245074935715E-13<>139.5455 #3601 1.5738023723650375E-12<>734.45 #3612 3.1476047447300757E-14<>14.689 #3622 4.7214071170951138E-14<>22.0335 #3632 6.2952094894601513E-14<>29.378 #3642 7.8690118618251895E-14<>36.7225 #3652 9.4428142341902276E-14<>44.067 #3662 1.1016616606555263E-13<>51.4115 #3672 1.2590418978920303E-13<>58.756 #3682 1.4164221351285338E-13<>66.1005 #3692 3.1476047447300748E-13<>146.89 #3702 3.3049849819665791E-13<>154.2345 #3712 3.4623652192030824E-13<>161.579 #3722 3.6197454564395862E-13<>168.9235 #3732 3.77712569367609E-13<>176.268 #3742 3.9345059309125944E-13<>183.6125 #3752 4.0918861681490982E-13<>190.957 #3762 4.249266405385602E-13<>198.3015 #3772 4.4066466426221053E-13<>205.646 #3782 4.5640268798586096E-13<>212.9905 #3792 4.7214071170951134E-13<>220.335 #3802 4.8787873543316172E-13<>227.6795 #3812 5.03616759156812E-13<>235.024 #3822 5.1935478288046249E-13<>242.3685 #3832 5.3509280660411287E-13<>249.713 #3842 5.5083083032776305E-13<>257.0575 #3852 5.6656885405141353E-13<>264.402 #3862 5.8230687777506391E-13<>271.7465 #3872 5.9804490149871429E-13<>279.091 #3882 6.1378292522236457E-13<>286.4355
#3892 6.2952094894601496E-13<>293.78 #3902 6.4525897266966544E-13<>301.1245 #3912 6.6099699639331582E-13<>308.469 #3922 6.767350201169662E-13<>315.8135 #3932 6.9247304384061648E-13<>323.158 #3942 7.0821106756426696E-13<>330.5025 #3952 7.2394909128791724E-13<>337.847 #3962 7.3968711501156763E-13<>345.1915 #3972 7.5542513873521801E-13<>352.536 #3982 7.7116316245886839E-13<>359.8805 #3992 7.8690118618251887E-13<>367.225 #4002 8.0263920990616925E-13<>374.5695 #4012 8.1837723362981963E-13<>381.914 #4022 8.3411525735347002E-13<>389.2585 #4032 8.498532810771204E-13<>396.603 #4042 8.6559130480077068E-13<>403.9475 #4052 8.8132932852442106E-13<>411.292 #4062 8.9706735224807144E-13<>418.6365 #4072 9.1280537597172192E-13<>425.981 #4082 9.285433996953723E-13<>433.3255 #4092 9.4428142341902269E-13<>440.67 #4102 9.6001944714267307E-13<>448.0145 #4112 9.7575747086632345E-13<>455.359 #4122 9.9149549458997363E-13<>462.7035 #4132 1.0072335183136242E-12<>470.048 #4142 1.0229715420372746E-12<>477.3925 #4152 1.038709565760925E-12<>484.737 #4162 1.0544475894845754E-12<>492.0815 #4172 1.0701856132082255E-12<>499.426 #4182 1.0859236369318759E-12<>506.7705 #4192 1.1016616606555263E-12<>514.115 #4202 1.1173996843791767E-12<>521.4595 #4212 1.1331377081028273E-12<>528.804 #4222 1.1488757318264774E-12<>536.1485 #4232 1.1646137555501278E-12<>543.493 #4242 1.1803517792737782E-12<>550.8375 #4252 1.1960898029974286E-12<>558.182 #4262 1.211827826721079E-12<>565.5265 #4272 1.2275658504447294E-12<>572.871 #4282 1.2433038741683795E-12<>580.2155 #4292 1.2590418978920299E-12<>587.56 #4302 1.2747799216156803E-12<>594.9045 #4312 1.2905179453393307E-12<>602.249 #4322 1.3062559690629812E-12<>609.5935 #4332 1.3219939927866316E-12<>616.938 #4342 1.337732016510282E-12<>624.2825 #4352 1.3534700402339324E-12<>631.627 #4362 1.3692080639575828E-12<>638.9715 #4372 1.3849460876812332E-12<>646.316 #4382 1.4006841114048835E-12<>653.6605 #4392 1.4164221351285339E-12<>661.005 #4402 1.4321601588521843E-12<>668.3495 #4412 1.4478981825758347E-12<>675.694 #4422 1.4636362062994851E-12<>683.0385 #4432 1.4793742300231354E-12<>690.383 #4442 1.4951122537467858E-12<>697.7275 #4452 1.5108502774704362E-12<>705.072 #4462 1.5265883011940866E-12<>712.4165 #4472 1.542326324917737E-12<>719.761
#4482 1.5580643486413874E-12<>727.1055 #4492 1.5738023723650374E-13<>73.445 #4500 ! ORM with acknowledge - Retrieve from SQL
! Exception EInvalidOp raised with messsage:
! Invalid floating point operation
#10 1.5738023723650378E-14<>7.3445 #19 3.1476047447300757E-14<>14.689 #28 4.7214071170951138E-14<>22.0335 #37 6.2952094894601513E-14<>29.378 #46 7.8690118618251895E-14<>36.7225 #55 9.4428142341902276E-14<>44.067 #64 1.1016616606555263E-13<>51.4115 #73 1.2590418978920303E-13<>58.756 #82 1.4164221351285338E-13<>66.1005 #91 1.5738023723650374E-13<>73.445 #100 1.7311826096015412E-13<>80.7895 #109 1.888562846838045E-13<>88.134 #118 2.0459430840745491E-13<>95.4785 #127 2.2033233213110526E-13<>102.823 #136 2.3607035585475567E-13<>110.1675 #145 2.51808379578406E-13<>117.512 #154 2.6754640330205643E-13<>124.8565 #163 2.8328442702570676E-13<>132.201 #172 2.9902245074935715E-13<>139.5455 #181 3.1476047447300748E-13<>146.89 #190 3.3049849819665791E-13<>154.2345 #199 3.4623652192030824E-13<>161.579 #208 3.6197454564395862E-13<>168.9235 #217 3.77712569367609E-13<>176.268 #226 3.9345059309125944E-13<>183.6125 #235 4.0918861681490982E-13<>190.957 #244 4.249266405385602E-13<>198.3015 #253 4.4066466426221053E-13<>205.646 #262 4.5640268798586096E-13<>212.9905 #271 4.7214071170951134E-13<>220.335 #280 4.8787873543316172E-13<>227.6795 #289 5.03616759156812E-13<>235.024 #298 5.1935478288046249E-13<>242.3685 #307 5.3509280660411287E-13<>249.713 #316 5.5083083032776305E-13<>257.0575 #325 5.6656885405141353E-13<>264.402 #334 5.8230687777506391E-13<>271.7465
#343 5.9804490149871429E-13<>279.091 #352 6.1378292522236457E-13<>286.4355 #361 6.2952094894601496E-13<>293.78 #370 6.4525897266966544E-13<>301.1245 #379 6.6099699639331582E-13<>308.469 #388 6.767350201169662E-13<>315.8135 #397 6.9247304384061648E-13<>323.158 #406 7.0821106756426696E-13<>330.5025 #415 7.2394909128791724E-13<>337.847 #424 7.3968711501156763E-13<>345.1915 #433 7.5542513873521801E-13<>352.536 #442 7.7116316245886829E-13<>359.8805 #451 7.8690118618251887E-13<>367.225 #460 8.0263920990616925E-13<>374.5695 #469 8.1837723362981963E-13<>381.914 #478 8.3411525735347002E-13<>389.2585 #487 8.498532810771204E-13<>396.603 #496 8.6559130480077068E-13<>403.9475 #505 8.8132932852442106E-13<>411.292 #514 8.9706735224807134E-13<>418.6365 #523 9.1280537597172192E-13<>425.981 #532 9.285433996953723E-13<>433.3255 #541 9.4428142341902269E-13<>440.67 #550 9.6001944714267307E-13<>448.0145 #559 9.7575747086632345E-13<>455.359 #568 9.9149549458997363E-13<>462.7035 #577 1.0072335183136242E-12<>470.048 #586 1.0229715420372746E-12<>477.3925 #595 1.038709565760925E-12<>484.737 #604 1.0544475894845754E-12<>492.0815 #613 1.0701856132082255E-12<>499.426 #622 1.0859236369318759E-12<>506.7705 #631 1.1016616606555263E-12<>514.115 #640 1.1173996843791767E-12<>521.4595 #649 1.1331377081028273E-12<>528.804 #658 1.1488757318264774E-12<>536.1485 #667 1.1646137555501278E-12<>543.493 #676 1.1803517792737782E-12<>550.8375 #685 1.1960898029974286E-12<>558.182 #694 1.211827826721079E-12<>565.5265 #703 1.2275658504447294E-12<>572.871 #712 1.2433038741683795E-12<>580.2155 #721 1.2590418978920299E-12<>587.56 #730 1.2747799216156803E-12<>594.9045 #739 1.2905179453393307E-12<>602.249 #748 1.3062559690629812E-12<>609.5935 #757 1.3219939927866316E-12<>616.938 #766 1.337732016510282E-12<>624.2825 #775 1.3534700402339324E-12<>631.627 #784 1.3692080639575828E-12<>638.9715 #793 1.3849460876812332E-12<>646.316 #802 1.4006841114048835E-12<>653.6605 #811 1.4164221351285339E-12<>661.005 #820 1.4321601588521843E-12<>668.3495 #829 1.4478981825758347E-12<>675.694 #838 1.4636362062994851E-12<>683.0385 #847 1.4793742300231354E-12<>690.383 #856 1.4951122537467858E-12<>697.7275 #865 1.5108502774704362E-12<>705.072 #874 1.5265883011940866E-12<>712.4165 #883 1.542326324917737E-12<>719.761 #892 1.5580643486413874E-12<>727.1055 #901 1.5738023723650375E-12<>734.45 ! - Update: 100 / 902 FAILED 24.76ms
100 rows updated in 22.97ms i.e. 4,352/s, aver. 229us, 1.5 MB/s
#109 1.5738023723650378E-14<>7.3445 #120 3.1476047447300757E-14<>14.689 #131 4.7214071170951138E-14<>22.0335 #142 6.2952094894601513E-14<>29.378 #153 7.8690118618251895E-14<>36.7225 #164 9.4428142341902276E-14<>44.067 #175 1.1016616606555263E-13<>51.4115 #186 1.2590418978920303E-13<>58.756 #197 1.4164221351285338E-13<>66.1005 #208 1.5738023723650374E-13<>73.445 #219 1.7311826096015412E-13<>80.7895 #230 1.888562846838045E-13<>88.134 #241 2.0459430840745491E-13<>95.4785 #252 2.2033233213110526E-13<>102.823 #263 2.3607035585475567E-13<>110.1675 #274 2.51808379578406E-13<>117.512 #285 2.6754640330205643E-13<>124.8565 #296 2.8328442702570676E-13<>132.201 #307 2.9902245074935715E-13<>139.5455 #318 3.1476047447300748E-13<>146.89 #329 3.3049849819665791E-13<>154.2345 #340 3.4623652192030824E-13<>161.579 #351 3.6197454564395862E-13<>168.9235 #362 3.77712569367609E-13<>176.268 #373 3.9345059309125944E-13<>183.6125 #384 4.0918861681490982E-13<>190.957 #395 4.249266405385602E-13<>198.3015 #406 4.4066466426221053E-13<>205.646 #417 4.5640268798586096E-13<>212.9905 #428 4.7214071170951134E-13<>220.335 #439 4.8787873543316172E-13<>227.6795 #450 5.03616759156812E-13<>235.024 #461 5.1935478288046249E-13<>242.3685 #472 5.3509280660411287E-13<>249.713 #483 5.5083083032776305E-13<>257.0575 #494 5.6656885405141353E-13<>264.402 #505 5.8230687777506391E-13<>271.7465 #516 5.9804490149871429E-13<>279.091 #527 6.1378292522236457E-13<>286.4355 #538 6.2952094894601496E-13<>293.78 #549 6.4525897266966544E-13<>301.1245 #560 6.6099699639331582E-13<>308.469 #571 6.767350201169662E-13<>315.8135 #582 6.9247304384061648E-13<>323.158 #593 7.0821106756426696E-13<>330.5025 #604 7.2394909128791724E-13<>337.847 #615 7.3968711501156763E-13<>345.1915 #626 7.5542513873521801E-13<>352.536 #637 7.7116316245886829E-13<>359.8805 #648 7.8690118618251887E-13<>367.225 #659 8.0263920990616925E-13<>374.5695 #670 8.1837723362981963E-13<>381.914 #681 8.3411525735347002E-13<>389.2585 #692 8.498532810771204E-13<>396.603 #703 8.6559130480077068E-13<>403.9475 #714 8.8132932852442106E-13<>411.292 #725 8.9706735224807134E-13<>418.6365 #736 9.1280537597172192E-13<>425.981 #747 9.285433996953723E-13<>433.3255 #758 9.4428142341902269E-13<>440.67 #769 9.6001944714267307E-13<>448.0145
#780 9.7575747086632345E-13<>455.359 #791 9.9149549458997363E-13<>462.7035 #802 1.0072335183136242E-12<>470.048 #813 1.0229715420372746E-12<>477.3925 #824 1.038709565760925E-12<>484.737 #835 1.0544475894845754E-12<>492.0815
#846 1.0701856132082255E-12<>499.426 #857 1.0859236369318759E-12<>506.7705 #868 1.1016616606555263E-12<>514.115 #879 1.1173996843791767E-12<>521.4595 #890 1.1331377081028273E-12<>528.804 #901 1.1488757318264774E-12<>536.1485 #912 1.1646137555501278E-12<>543.493 #923 1.1803517792737782E-12<>550.8375 #934 1.1960898029974286E-12<>558.182 #945 1.211827826721079E-12<>565.5265 #956 1.2275658504447294E-12<>572.871 #967 1.2433038741683795E-12<>580.2155 #978 1.2590418978920299E-12<>587.56 #989 1.2747799216156803E-12<>594.9045 #1000 1.2905179453393307E-12<>602.249 #1011 1.3062559690629812E-12<>609.5935 #1022 1.3219939927866316E-12<>616.938 #1033 1.337732016510282E-12<>624.2825 #1044 1.3534700402339324E-12<>631.627 #1055 1.3692080639575828E-12<>638.9715 #1066 1.3849460876812332E-12<>646.316 #1077 1.4006841114048835E-12<>653.6605 #1088 1.4164221351285339E-12<>661.005 #1099 1.4321601588521843E-12<>668.3495
#1110 1.4478981825758347E-12<>675.694 #1121 1.4636362062994851E-12<>683.0385 #1132 1.4793742300231354E-12<>690.383 #1143 1.4951122537467858E-12<>697.7275 #1154 1.5108502774704362E-12<>705.072 #1165 1.5265883011940866E-12<>712.4165 #1176 1.542326324917737E-12<>719.761 #1187 1.5580643486413874E-12<>727.1055 #1198 1.5738023723650375E-12<>734.45 #1511 1.5738023723650378E-14<>7.3445 #1523 3.1476047447300757E-14<>14.689 #1535 4.7214071170951138E-14<>22.0335 #1547 6.2952094894601513E-14<>29.378 #1559 7.8690118618251895E-14<>36.7225 #1571 9.4428142341902276E-14<>44.067 #1583 1.1016616606555263E-13<>51.4115 #1595 1.2590418978920303E-13<>58.756 #1607 1.4164221351285338E-13<>66.1005 #1619 1.5738023723650374E-13<>73.445 #1631 1.7311826096015412E-13<>80.7895 #1643 1.888562846838045E-13<>88.134 #1655 2.0459430840745491E-13<>95.4785 #1667 2.2033233213110526E-13<>102.823 #1679 2.3607035585475567E-13<>110.1675 #1691 2.51808379578406E-13<>117.512 #1703 2.6754640330205643E-13<>124.8565 #1715 2.8328442702570676E-13<>132.201 #1727 2.9902245074935715E-13<>139.5455 #1739 3.1476047447300748E-13<>146.89 #1751 3.3049849819665791E-13<>154.2345 #1763 3.4623652192030824E-13<>161.579 #1775 3.6197454564395862E-13<>168.9235 #1787 3.77712569367609E-13<>176.268 #1799 3.9345059309125944E-13<>183.6125 #1811 4.0918861681490982E-13<>190.957 #1823 4.249266405385602E-13<>198.3015 #1835 4.4066466426221053E-13<>205.646 #1847 4.5640268798586096E-13<>212.9905 #1859 4.7214071170951134E-13<>220.335 #1871 4.8787873543316172E-13<>227.6795 #1883 5.03616759156812E-13<>235.024 #1895 5.1935478288046249E-13<>242.3685 #1907 5.3509280660411287E-13<>249.713 #1919 5.5083083032776305E-13<>257.0575 #1931 5.6656885405141353E-13<>264.402 #1943 5.8230687777506391E-13<>271.7465 #1955 5.9804490149871429E-13<>279.091 #1967 6.1378292522236457E-13<>286.4355 #1979 6.2952094894601496E-13<>293.78 #1991 6.4525897266966544E-13<>301.1245 #2003 6.6099699639331582E-13<>308.469 #2015 6.767350201169662E-13<>315.8135 #2027 6.9247304384061648E-13<>323.158 #2039 7.0821106756426696E-13<>330.5025 #2051 7.2394909128791724E-13<>337.847 #2063 7.3968711501156763E-13<>345.1915 #2075 7.5542513873521801E-13<>352.536 #2087 7.7116316245886829E-13<>359.8805 #2099 7.8690118618251887E-13<>367.225 #2111 8.0263920990616925E-13<>374.5695 #2123 8.1837723362981963E-13<>381.914 #2135 8.3411525735347002E-13<>389.2585 #2147 8.498532810771204E-13<>396.603 #2159 8.6559130480077068E-13<>403.9475 #2171 8.8132932852442106E-13<>411.292 #2183 8.9706735224807134E-13<>418.6365 #2195 9.1280537597172192E-13<>425.981 #2207 9.285433996953723E-13<>433.3255 #2219 9.4428142341902269E-13<>440.67 #2231 9.6001944714267307E-13<>448.0145 #2243 9.7575747086632345E-13<>455.359 #2255 9.9149549458997363E-13<>462.7035 #2267 1.0072335183136242E-12<>470.048 #2279 1.0229715420372746E-12<>477.3925 #2291 1.038709565760925E-12<>484.737 #2303 1.0544475894845754E-12<>492.0815 #2315 1.0701856132082255E-12<>499.426 #2327 1.0859236369318759E-12<>506.7705 #2339 1.1016616606555263E-12<>514.115 #2351 1.1173996843791767E-12<>521.4595 #2363 1.1331377081028273E-12<>528.804 #2375 1.1488757318264774E-12<>536.1485 #2387 1.1646137555501278E-12<>543.493
#2399 1.1803517792737782E-12<>550.8375 #2411 1.1960898029974286E-12<>558.182 #2423 1.211827826721079E-12<>565.5265 #2435 1.2275658504447294E-12<>572.871 #2447 1.2433038741683795E-12<>580.2155 #2459 1.2590418978920299E-12<>587.56 #2471 1.2747799216156803E-12<>594.9045 #2483 1.2905179453393307E-12<>602.249 #2495 1.3062559690629812E-12<>609.5935 #2507 1.3219939927866316E-12<>616.938 #2519 1.337732016510282E-12<>624.2825 #2531 1.3534700402339324E-12<>631.627 #2543 1.3692080639575828E-12<>638.9715 #2555 1.3849460876812332E-12<>646.316 #2567 1.4006841114048835E-12<>653.6605 #2579 1.4164221351285339E-12<>661.005 #2591 1.4321601588521843E-12<>668.3495 #2603 1.4478981825758347E-12<>675.694 #2615 1.4636362062994851E-12<>683.0385 #2627 1.4793742300231354E-12<>690.383 #2639 1.4951122537467858E-12<>697.7275 #2651 1.5108502774704362E-12<>705.072 #2663 1.5265883011940866E-12<>712.4165 #2675 1.542326324917737E-12<>719.761 #2687 1.5580643486413874E-12<>727.1055 #2699 1.5738023723650375E-12<>734.45 ! - Blobs: 200 / 2,707 FAILED 77.83ms
100 rows updated in 18.84ms i.e. 5,305/s, aver. 188us, 1.4 MB/s
#27 1.5738023723650378E-14<>7.3445 #36 3.1476047447300757E-14<>14.689 #45 4.7214071170951138E-14<>22.0335 #54 6.2952094894601513E-14<>29.378 #63 9.4428142341902276E-14<>44.067 #72 1.1016616606555263E-13<>51.4115 #81 1.2590418978920303E-13<>58.756 #90 1.4164221351285338E-13<>66.1005 #99 1.7311826096015412E-13<>80.7895 #108 1.888562846838045E-13<>88.134 #117 2.0459430840745491E-13<>95.4785 #126 2.2033233213110526E-13<>102.823 #135 2.51808379578406E-13<>117.512 #144 2.6754640330205643E-13<>124.8565 #153 2.8328442702570676E-13<>132.201 #162 2.9902245074935715E-13<>139.5455 #171 3.3049849819665791E-13<>154.2345 #180 3.4623652192030824E-13<>161.579 #189 3.6197454564395862E-13<>168.9235 #198 3.77712569367609E-13<>176.268 #207 4.0918861681490982E-13<>190.957 #216 4.249266405385602E-13<>198.3015 #225 4.4066466426221053E-13<>205.646 #234 4.5640268798586096E-13<>212.9905 #243 4.8787873543316172E-13<>227.6795 #252 5.03616759156812E-13<>235.024 #261 5.1935478288046249E-13<>242.3685 #270 5.3509280660411287E-13<>249.713 #279 5.6656885405141353E-13<>264.402 #288 5.8230687777506391E-13<>271.7465 #297 5.9804490149871429E-13<>279.091 #306 6.1378292522236457E-13<>286.4355 #315 6.4525897266966544E-13<>301.1245 #324 6.6099699639331582E-13<>308.469 #333 6.767350201169662E-13<>315.8135 #342 6.9247304384061648E-13<>323.158 #351 7.2394909128791724E-13<>337.847
#360 7.3968711501156763E-13<>345.1915 #369 7.5542513873521801E-13<>352.536 #378 7.7116316245886829E-13<>359.8805 #387 8.0263920990616925E-13<>374.5695 #396 8.1837723362981963E-13<>381.914 #405 8.3411525735347002E-13<>389.2585
#414 8.498532810771204E-13<>396.603 #423 8.8132932852442106E-13<>411.292 #432 8.9706735224807134E-13<>418.6365 #441 9.1280537597172192E-13<>425.981 #450 9.285433996953723E-13<>433.3255 #459 9.6001944714267307E-13<>448.0145
#468 9.7575747086632345E-13<>455.359 #477 9.9149549458997363E-13<>462.7035 #486 1.0072335183136242E-12<>470.048 #495 1.038709565760925E-12<>484.737 #504 1.0544475894845754E-12<>492.0815 #513 1.0701856132082255E-12<>499.426 #522 1.0859236369318759E-12<>506.7705 #531 1.1173996843791767E-12<>521.4595 #540 1.1331377081028273E-12<>528.804 #549 1.1488757318264774E-12<>536.1485 #558 1.1646137555501278E-12<>543.493 #567 1.1960898029974286E-12<>558.182 #576 1.211827826721079E-12<>565.5265 #585 1.2275658504447294E-12<>572.871 #594 1.2433038741683795E-12<>580.2155 #603 1.2747799216156803E-12<>594.9045 #612 1.2905179453393307E-12<>602.249 #621 1.3062559690629812E-12<>609.5935 #630 1.3219939927866316E-12<>616.938 #639 1.3534700402339324E-12<>631.627 #648 1.3692080639575828E-12<>638.9715 #657 1.3849460876812332E-12<>646.316 #666 1.4006841114048835E-12<>653.6605 #675 1.4321601588521843E-12<>668.3495 #684 1.4478981825758347E-12<>675.694 #693 1.4636362062994851E-12<>683.0385 #702 1.4793742300231354E-12<>690.383 #711 1.5108502774704362E-12<>705.072 #720 1.5265883011940866E-12<>712.4165 #729 1.542326324917737E-12<>719.761 #738 1.5580643486413874E-12<>727.1055 ! - Delete: 80 / 843 FAILED 35.93ms
20 rows deleted in 3.65ms i.e. 5,476/s, aver. 182us, 1 MB/s
#31 1.5738023723650378E-14<>7.3445 #40 3.1476047447300757E-14<>14.689 #49 4.7214071170951138E-14<>22.0335 #58 6.2952094894601513E-14<>29.378 #67 9.4428142341902276E-14<>44.067 #76 1.1016616606555263E-13<>51.4115 #85 1.2590418978920303E-13<>58.756 #94 1.4164221351285338E-13<>66.1005 #103 1.7311826096015412E-13<>80.7895 #112 1.888562846838045E-13<>88.134 #121 2.0459430840745491E-13<>95.4785 #130 2.2033233213110526E-13<>102.823 #139 2.51808379578406E-13<>117.512 #148 2.6754640330205643E-13<>124.8565 #157 2.8328442702570676E-13<>132.201 #166 2.9902245074935715E-13<>139.5455 #175 3.3049849819665791E-13<>154.2345 #184 3.4623652192030824E-13<>161.579 #193 3.6197454564395862E-13<>168.9235 #202 3.77712569367609E-13<>176.268 #211 4.0918861681490982E-13<>190.957 #220 4.249266405385602E-13<>198.3015 #229 4.4066466426221053E-13<>205.646 #238 4.5640268798586096E-13<>212.9905 #247 4.8787873543316172E-13<>227.6795 #256 5.03616759156812E-13<>235.024 #265 5.1935478288046249E-13<>242.3685 #274 5.3509280660411287E-13<>249.713 #283 5.6656885405141353E-13<>264.402 #292 5.8230687777506391E-13<>271.7465 #301 5.9804490149871429E-13<>279.091 #310 6.1378292522236457E-13<>286.4355 #319 6.4525897266966544E-13<>301.1245 #328 6.6099699639331582E-13<>308.469 #337 6.767350201169662E-13<>315.8135 #346 6.9247304384061648E-13<>323.158 #355 7.2394909128791724E-13<>337.847 #364 7.3968711501156763E-13<>345.1915 #373 7.5542513873521801E-13<>352.536 #382 7.7116316245886839E-13<>359.8805 #391 8.0263920990616925E-13<>374.5695 #400 8.1837723362981963E-13<>381.914 #409 8.3411525735347002E-13<>389.2585 #418 8.498532810771204E-13<>396.603 #427 8.8132932852442106E-13<>411.292 #436 8.9706735224807144E-13<>418.6365 #445 9.1280537597172192E-13<>425.981 #454 9.285433996953723E-13<>433.3255 #463 9.6001944714267307E-13<>448.0145
#472 9.7575747086632345E-13<>455.359 #481 9.9149549458997363E-13<>462.7035 #490 1.0072335183136242E-12<>470.048 #499 1.038709565760925E-12<>484.737 #508 1.0544475894845754E-12<>492.0815 #517 1.0701856132082255E-12<>499.426 #526 1.0859236369318759E-12<>506.7705 #535 1.1173996843791767E-12<>521.4595 #544 1.1331377081028273E-12<>528.804 #553 1.1488757318264774E-12<>536.1485 #562 1.1646137555501278E-12<>543.493 #571 1.1960898029974286E-12<>558.182 #580 1.211827826721079E-12<>565.5265 #589 1.2275658504447294E-12<>572.871 #598 1.2433038741683795E-12<>580.2155 #607 1.2747799216156803E-12<>594.9045 #616 1.2905179453393307E-12<>602.249 #625 1.3062559690629812E-12<>609.5935 #634 1.3219939927866316E-12<>616.938 #643 1.3534700402339324E-12<>631.627 #652 1.3692080639575828E-12<>638.9715 #661 1.3849460876812332E-12<>646.316 #670 1.4006841114048835E-12<>653.6605 #679 1.4321601588521843E-12<>668.3495 #688 1.4478981825758347E-12<>675.694 #697 1.4636362062994851E-12<>683.0385 #706 1.4793742300231354E-12<>690.383 #715 1.5108502774704362E-12<>705.072 #724 1.5265883011940866E-12<>712.4165 #733 1.542326324917737E-12<>719.761 #742 1.5580643486413874E-12<>727.1055 ! - Delete in batch mode: 80 / 743 FAILED 2.98ms
20 rows deleted in 951us i.e. 21,030/s, aver. 47us, 396.3 KB/s
Total failed: 1,211 / 12,809 - ORM with acknowledge FAILED 400.32ms
2.2. ORM without acknowledge:
- Connect to local server: 6 assertions passed 37.29ms
- Insert: 102 assertions passed 35.14ms
100 rows inserted in 3.98ms i.e. 25,081/s, aver. 39us, 3.7 MB/s
- Insert in batch mode: 104 assertions passed 26.90ms
100 rows inserted in 3.59ms i.e. 27,824/s, aver. 35us, 3.3 MB/s
#11 1.5738023723650378E-14<>7.3445 #21 3.1476047447300757E-14<>14.689 #31 4.7214071170951138E-14<>22.0335 #41 6.2952094894601513E-14<>29.378 #51 7.8690118618251895E-14<>36.7225 #61 9.4428142341902276E-14<>44.067 #71 1.1016616606555263E-13<>51.4115 #81 1.2590418978920303E-13<>58.756 #91 1.4164221351285338E-13<>66.1005 #101 1.5738023723650374E-13<>73.445 #111 1.7311826096015412E-13<>80.7895 #121 1.888562846838045E-13<>88.134 #131 2.0459430840745491E-13<>95.4785 #141 2.2033233213110526E-13<>102.823 #151 2.3607035585475567E-13<>110.1675 #161 2.51808379578406E-13<>117.512 #171 2.6754640330205643E-13<>124.8565 #181 2.8328442702570676E-13<>132.201 #191 2.9902245074935715E-13<>139.5455 #201 3.1476047447300748E-13<>146.89 #211 3.3049849819665791E-13<>154.2345 #221 3.4623652192030824E-13<>161.579 #231 3.6197454564395862E-13<>168.9235 #241 3.77712569367609E-13<>176.268 #251 3.9345059309125944E-13<>183.6125 #261 4.0918861681490982E-13<>190.957 #271 4.249266405385602E-13<>198.3015 #281 4.4066466426221053E-13<>205.646 #291 4.5640268798586096E-13<>212.9905 #301 4.7214071170951134E-13<>220.335 #311 4.8787873543316172E-13<>227.6795 #321 5.03616759156812E-13<>235.024 #331 5.1935478288046249E-13<>242.3685 #341 5.3509280660411287E-13<>249.713 #351 5.5083083032776305E-13<>257.0575 #361 5.6656885405141353E-13<>264.402 #371 5.8230687777506391E-13<>271.7465
#381 5.9804490149871429E-13<>279.091 #391 6.1378292522236457E-13<>286.4355 #401 6.2952094894601496E-13<>293.78 #411 6.4525897266966544E-13<>301.1245 #421 6.6099699639331582E-13<>308.469 #431 6.767350201169662E-13<>315.8135 #441 6.9247304384061648E-13<>323.158 #451 7.0821106756426696E-13<>330.5025 #461 7.2394909128791724E-13<>337.847 #471 7.3968711501156763E-13<>345.1915 #481 7.5542513873521801E-13<>352.536 #491 7.7116316245886839E-13<>359.8805 #501 7.8690118618251887E-13<>367.225 #511 8.0263920990616925E-13<>374.5695 #521 8.1837723362981963E-13<>381.914 #531 8.3411525735347002E-13<>389.2585 #541 8.498532810771204E-13<>396.603 #551 8.6559130480077068E-13<>403.9475 #561 8.8132932852442106E-13<>411.292 #571 8.9706735224807144E-13<>418.6365 #581 9.1280537597172192E-13<>425.981 #591 9.285433996953723E-13<>433.3255 #601 9.4428142341902269E-13<>440.67 #611 9.6001944714267307E-13<>448.0145 #621 9.7575747086632345E-13<>455.359 #631 9.9149549458997363E-13<>462.7035 #641 1.0072335183136242E-12<>470.048 #651 1.0229715420372746E-12<>477.3925 #661 1.038709565760925E-12<>484.737 #671 1.0544475894845754E-12<>492.0815 #681 1.0701856132082255E-12<>499.426 #691 1.0859236369318759E-12<>506.7705 #701 1.1016616606555263E-12<>514.115 #711 1.1173996843791767E-12<>521.4595 #721 1.1331377081028273E-12<>528.804 #731 1.1488757318264774E-12<>536.1485 #741 1.1646137555501278E-12<>543.493 #751 1.1803517792737782E-12<>550.8375 #761 1.1960898029974286E-12<>558.182 #771 1.211827826721079E-12<>565.5265 #781 1.2275658504447294E-12<>572.871 #791 1.2433038741683795E-12<>580.2155 #801 1.2590418978920299E-12<>587.56 #811 1.2747799216156803E-12<>594.9045 #821 1.2905179453393307E-12<>602.249 #831 1.3062559690629812E-12<>609.5935 #841 1.3219939927866316E-12<>616.938 #851 1.337732016510282E-12<>624.2825 #861 1.3534700402339324E-12<>631.627 #871 1.3692080639575828E-12<>638.9715 #881 1.3849460876812332E-12<>646.316 #891 1.4006841114048835E-12<>653.6605 #901 1.4164221351285339E-12<>661.005 #911 1.4321601588521843E-12<>668.3495 #921 1.4478981825758347E-12<>675.694 #931 1.4636362062994851E-12<>683.0385 #941 1.4793742300231354E-12<>690.383 #951 1.4951122537467858E-12<>697.7275 #961 1.5108502774704362E-12<>705.072 #971 1.5265883011940866E-12<>712.4165 #981 1.542326324917737E-12<>719.761 #991 1.5580643486413874E-12<>727.1055 #1001 1.5738023723650375E-12<>734.45 ! - Retrieve: 100 / 1,001 FAILED 21.78ms
100 rows retrieved in 21.77ms i.e. 4,593/s, aver. 217us, 1.3 MB/s
#9 1.5738023723650378E-14<>7.3445 #18 3.1476047447300757E-14<>14.689 #27 4.7214071170951138E-14<>22.0335 #36 6.2952094894601513E-14<>29.378 #45 7.8690118618251895E-14<>36.7225 #54 9.4428142341902276E-14<>44.067 #63 1.1016616606555263E-13<>51.4115 #72 1.2590418978920303E-13<>58.756 #81 1.4164221351285338E-13<>66.1005 #90 1.5738023723650374E-13<>73.445 #99 1.7311826096015412E-13<>80.7895 #108 1.888562846838045E-13<>88.134 #117 2.0459430840745491E-13<>95.4785 #126 2.2033233213110526E-13<>102.823 #135 2.3607035585475567E-13<>110.1675 #144 2.51808379578406E-13<>117.512 #153 2.6754640330205643E-13<>124.8565 #162 2.8328442702570676E-13<>132.201 #171 2.9902245074935715E-13<>139.5455 #180 3.1476047447300748E-13<>146.89 #189 3.3049849819665791E-13<>154.2345 #198 3.4623652192030824E-13<>161.579 #207 3.6197454564395862E-13<>168.9235 #216 3.77712569367609E-13<>176.268 #225 3.9345059309125944E-13<>183.6125 #234 4.0918861681490982E-13<>190.957 #243 4.249266405385602E-13<>198.3015 #252 4.4066466426221053E-13<>205.646 #261 4.5640268798586096E-13<>212.9905 #270 4.7214071170951134E-13<>220.335 #279 4.8787873543316172E-13<>227.6795
#288 5.03616759156812E-13<>235.024 #297 5.1935478288046249E-13<>242.3685 #306 5.3509280660411287E-13<>249.713 #315 5.5083083032776305E-13<>257.0575 #324 5.6656885405141353E-13<>264.402 #333 5.8230687777506391E-13<>271.7465 #342 5.9804490149871429E-13<>279.091 #351 6.1378292522236457E-13<>286.4355 #360 6.2952094894601496E-13<>293.78 #369 6.4525897266966544E-13<>301.1245 #378 6.6099699639331582E-13<>308.469 #387 6.767350201169662E-13<>315.8135 #396 6.9247304384061648E-13<>323.158 #405 7.0821106756426696E-13<>330.5025 #414 7.2394909128791724E-13<>337.847 #423 7.3968711501156763E-13<>345.1915 #432 7.5542513873521801E-13<>352.536 #441 7.7116316245886839E-13<>359.8805 #450 7.8690118618251887E-13<>367.225 #459 8.0263920990616925E-13<>374.5695 #468 8.1837723362981963E-13<>381.914 #477 8.3411525735347002E-13<>389.2585 #486 8.498532810771204E-13<>396.603 #495 8.6559130480077068E-13<>403.9475 #504 8.8132932852442106E-13<>411.292 #513 8.9706735224807144E-13<>418.6365 #522 9.1280537597172192E-13<>425.981 #531 9.285433996953723E-13<>433.3255 #540 9.4428142341902269E-13<>440.67 #549 9.6001944714267307E-13<>448.0145 #558 9.7575747086632345E-13<>455.359 #567 9.9149549458997363E-13<>462.7035 #576 1.0072335183136242E-12<>470.048 #585 1.0229715420372746E-12<>477.3925 #594 1.038709565760925E-12<>484.737 #603 1.0544475894845754E-12<>492.0815 #612 1.0701856132082255E-12<>499.426 #621 1.0859236369318759E-12<>506.7705 #630 1.1016616606555263E-12<>514.115 #639 1.1173996843791767E-12<>521.4595 #648 1.1331377081028273E-12<>528.804 #657 1.1488757318264774E-12<>536.1485 #666 1.1646137555501278E-12<>543.493 #675 1.1803517792737782E-12<>550.8375 #684 1.1960898029974286E-12<>558.182 #693 1.211827826721079E-12<>565.5265 #702 1.2275658504447294E-12<>572.871 #711 1.2433038741683795E-12<>580.2155 #720 1.2590418978920299E-12<>587.56 #729 1.2747799216156803E-12<>594.9045 #738 1.2905179453393307E-12<>602.249 #747 1.3062559690629812E-12<>609.5935 #756 1.3219939927866316E-12<>616.938 #765 1.337732016510282E-12<>624.2825 #774 1.3534700402339324E-12<>631.627 #783 1.3692080639575828E-12<>638.9715 #792 1.3849460876812332E-12<>646.316 #801 1.4006841114048835E-12<>653.6605 #810 1.4164221351285339E-12<>661.005 #819 1.4321601588521843E-12<>668.3495 #828 1.4478981825758347E-12<>675.694 #837 1.4636362062994851E-12<>683.0385 #846 1.4793742300231354E-12<>690.383 #855 1.4951122537467858E-12<>697.7275 #864 1.5108502774704362E-12<>705.072 #873 1.5265883011940866E-12<>712.4165 #882 1.542326324917737E-12<>719.761 #891 1.5580643486413874E-12<>727.1055 #900 1.5738023723650375E-12<>734.45 ! - Retrieve all: 100 / 901 FAILED 2.52ms
100 rows retrieved in 2.51ms i.e. 39,824/s, aver. 25us, 4.8 MB/s
#9 1.5738023723650378E-14<>7.3445 #19 3.1476047447300757E-14<>14.689 #29 4.7214071170951138E-14<>22.0335 #39 6.2952094894601513E-14<>29.378 #49 7.8690118618251895E-14<>36.7225 #59 9.4428142341902276E-14<>44.067 #69 1.1016616606555263E-13<>51.4115 #79 1.2590418978920303E-13<>58.756 #89 1.4164221351285338E-13<>66.1005 #99 1.5738023723650374E-13<>73.445 #109 1.7311826096015412E-13<>80.7895 #119 1.888562846838045E-13<>88.134 #129 2.0459430840745491E-13<>95.4785 #139 2.2033233213110526E-13<>102.823 #149 2.3607035585475567E-13<>110.1675 #159 2.51808379578406E-13<>117.512 #169 2.6754640330205643E-13<>124.8565 #179 2.8328442702570676E-13<>132.201 #189 2.9902245074935715E-13<>139.5455 #199 3.1476047447300748E-13<>146.89 #209 3.3049849819665791E-13<>154.2345 #219 3.4623652192030824E-13<>161.579 #229 3.6197454564395862E-13<>168.9235 #239 3.77712569367609E-13<>176.268 #249 3.9345059309125944E-13<>183.6125 #259 4.0918861681490982E-13<>190.957 #269 4.249266405385602E-13<>198.3015 #279 4.4066466426221053E-13<>205.646 #289 4.5640268798586096E-13<>212.9905 #299 4.7214071170951134E-13<>220.335 #309 4.8787873543316172E-13<>227.6795
#319 5.03616759156812E-13<>235.024 #329 5.1935478288046249E-13<>242.3685 #339 5.3509280660411287E-13<>249.713 #349 5.5083083032776305E-13<>257.0575 #359 5.6656885405141353E-13<>264.402 #369 5.8230687777506391E-13<>271.7465
#379 5.9804490149871429E-13<>279.091 #389 6.1378292522236457E-13<>286.4355 #399 6.2952094894601496E-13<>293.78 #409 6.4525897266966544E-13<>301.1245 #419 6.6099699639331582E-13<>308.469 #429 6.767350201169662E-13<>315.8135 #439 6.9247304384061648E-13<>323.158 #449 7.0821106756426696E-13<>330.5025 #459 7.2394909128791724E-13<>337.847 #469 7.3968711501156763E-13<>345.1915 #479 7.5542513873521801E-13<>352.536 #489 7.7116316245886839E-13<>359.8805 #499 7.8690118618251887E-13<>367.225 #509 8.0263920990616925E-13<>374.5695 #519 8.1837723362981963E-13<>381.914 #529 8.3411525735347002E-13<>389.2585 #539 8.498532810771204E-13<>396.603 #549 8.6559130480077068E-13<>403.9475 #559 8.8132932852442106E-13<>411.292 #569 8.9706735224807144E-13<>418.6365 #579 9.1280537597172192E-13<>425.981 #589 9.285433996953723E-13<>433.3255 #599 9.4428142341902269E-13<>440.67 #609 9.6001944714267307E-13<>448.0145 #619 9.7575747086632345E-13<>455.359 #629 9.9149549458997363E-13<>462.7035 #639 1.0072335183136242E-12<>470.048 #649 1.0229715420372746E-12<>477.3925 #659 1.038709565760925E-12<>484.737 #669 1.0544475894845754E-12<>492.0815 #679 1.0701856132082255E-12<>499.426 #689 1.0859236369318759E-12<>506.7705 #699 1.1016616606555263E-12<>514.115 #709 1.1173996843791767E-12<>521.4595 #719 1.1331377081028273E-12<>528.804 #729 1.1488757318264774E-12<>536.1485 #739 1.1646137555501278E-12<>543.493 #749 1.1803517792737782E-12<>550.8375 #759 1.1960898029974286E-12<>558.182 #769 1.211827826721079E-12<>565.5265 #779 1.2275658504447294E-12<>572.871 #789 1.2433038741683795E-12<>580.2155 #799 1.2590418978920299E-12<>587.56 #809 1.2747799216156803E-12<>594.9045 #819 1.2905179453393307E-12<>602.249 #829 1.3062559690629812E-12<>609.5935 #839 1.3219939927866316E-12<>616.938 #849 1.337732016510282E-12<>624.2825 #859 1.3534700402339324E-12<>631.627 #869 1.3692080639575828E-12<>638.9715 #879 1.3849460876812332E-12<>646.316 #889 1.4006841114048835E-12<>653.6605 #899 1.4164221351285339E-12<>661.005 #909 1.4321601588521843E-12<>668.3495 #919 1.4478981825758347E-12<>675.694 #929 1.4636362062994851E-12<>683.0385 #939 1.4793742300231354E-12<>690.383 #949 1.4951122537467858E-12<>697.7275 #959 1.5108502774704362E-12<>705.072 #969 1.5265883011940866E-12<>712.4165 #979 1.542326324917737E-12<>719.761 #989 1.5580643486413874E-12<>727.1055 #999 1.5738023723650375E-12<>734.45 ! - Retrieve one with where clause: 100 / 1,000 FAILED 38.01ms
100 rows retrieved in 37.90ms i.e. 2,637/s, aver. 379us, 788 KB/s
#9 6.767350201169662E-13<>315.8135 #19 1.5738023723650378E-14<>7.3445 #29 3.1476047447300757E-14<>14.689 #39 4.7214071170951138E-14<>22.0335 #49 6.2952094894601513E-14<>29.378 #59 7.8690118618251895E-14<>36.7225 #69 9.4428142341902276E-14<>44.067 #79 1.1016616606555263E-13<>51.4115 #89 1.2590418978920303E-13<>58.756 #99 1.4164221351285338E-13<>66.1005 #109 1.5738023723650374E-13<>73.445 #119 1.7311826096015412E-13<>80.7895 #129 1.888562846838045E-13<>88.134 #139 2.0459430840745491E-13<>95.4785 #149 2.2033233213110526E-13<>102.823 #159 2.3607035585475567E-13<>110.1675 #169 2.51808379578406E-13<>117.512 #179 2.6754640330205643E-13<>124.8565 #189 2.8328442702570676E-13<>132.201 #199 2.9902245074935715E-13<>139.5455 #209 3.1476047447300748E-13<>146.89 #219 3.3049849819665791E-13<>154.2345 #229 3.4623652192030824E-13<>161.579 #239 3.6197454564395862E-13<>168.9235 #249 3.77712569367609E-13<>176.268 #259 3.9345059309125944E-13<>183.6125 #269 4.0918861681490982E-13<>190.957 #279 4.249266405385602E-13<>198.3015 #289 4.4066466426221053E-13<>205.646 #299 4.5640268798586096E-13<>212.9905 #309 4.7214071170951134E-13<>220.335
#319 4.8787873543316172E-13<>227.6795 #329 5.03616759156812E-13<>235.024 #339 5.1935478288046249E-13<>242.3685 #349 5.3509280660411287E-13<>249.713 #359 5.5083083032776305E-13<>257.0575 #369 5.6656885405141353E-13<>264.402 #379 5.8230687777506391E-13<>271.7465 #389 5.9804490149871429E-13<>279.091 #399 6.1378292522236457E-13<>286.4355 #409 6.2952094894601496E-13<>293.78 #419 6.4525897266966544E-13<>301.1245 #429 6.6099699639331582E-13<>308.469 #439 6.767350201169662E-13<>315.8135 #449 6.9247304384061648E-13<>323.158 #459 7.0821106756426696E-13<>330.5025 #469 7.2394909128791724E-13<>337.847 #479 7.3968711501156763E-13<>345.1915 #489 7.5542513873521801E-13<>352.536 #499 7.7116316245886839E-13<>359.8805 #509 7.8690118618251887E-13<>367.225 #519 1.0072335183136242E-12<>470.048 #529 1.0229715420372746E-12<>477.3925 #539 1.038709565760925E-12<>484.737 #549 1.0544475894845754E-12<>492.0815 #559 1.0701856132082255E-12<>499.426 #569 1.0859236369318759E-12<>506.7705 #579 1.1016616606555263E-12<>514.115 #589 1.1173996843791767E-12<>521.4595 #599 1.1331377081028273E-12<>528.804 #609 1.1488757318264774E-12<>536.1485 #619 1.1646137555501278E-12<>543.493 #629 1.1803517792737782E-12<>550.8375 #639 1.1960898029974286E-12<>558.182 #649 1.211827826721079E-12<>565.5265 #659 1.2275658504447294E-12<>572.871 #669 1.2433038741683795E-12<>580.2155 #679 1.2590418978920299E-12<>587.56 #689 1.2747799216156803E-12<>594.9045 #699 1.2905179453393307E-12<>602.249 #709 1.3062559690629812E-12<>609.5935 #719 1.3219939927866316E-12<>616.938 #729 1.337732016510282E-12<>624.2825 #739 1.3534700402339324E-12<>631.627 #749 1.3692080639575828E-12<>638.9715 #759 1.3849460876812332E-12<>646.316 #769 1.4006841114048835E-12<>653.6605 #779 1.4164221351285339E-12<>661.005 #789 1.4321601588521843E-12<>668.3495 #799 1.4478981825758347E-12<>675.694 #809 1.4636362062994851E-12<>683.0385 #819 1.4793742300231354E-12<>690.383 #829 1.4951122537467858E-12<>697.7275 #839 1.5108502774704362E-12<>705.072 #849 1.5265883011940866E-12<>712.4165 #859 1.542326324917737E-12<>719.761 #869 1.5580643486413874E-12<>727.1055 #879 1.5738023723650375E-12<>734.45 #890 1.5738023723650378E-14<>7.3445 #900 3.1476047447300757E-14<>14.689 #910 4.7214071170951138E-14<>22.0335 #920 6.2952094894601513E-14<>29.378 #930 7.8690118618251895E-14<>36.7225 #940 9.4428142341902276E-14<>44.067 #950 1.1016616606555263E-13<>51.4115 #960 1.2590418978920303E-13<>58.756 #970 1.4164221351285338E-13<>66.1005 #980 1.5738023723650374E-13<>73.445 #990 1.7311826096015412E-13<>80.7895 #1000 1.888562846838045E-13<>88.134 #1010 2.0459430840745491E-13<>95.4785 #1020 2.2033233213110526E-13<>102.823 #1030 2.3607035585475567E-13<>110.1675 #1040 2.51808379578406E-13<>117.512 #1050 2.6754640330205643E-13<>124.8565 #1060 2.8328442702570676E-13<>132.201 #1070 2.9902245074935715E-13<>139.5455 #1080 3.1476047447300748E-13<>146.89 #1090 3.3049849819665791E-13<>154.2345 #1100 3.4623652192030824E-13<>161.579 #1110 3.6197454564395862E-13<>168.9235 #1120 3.77712569367609E-13<>176.268 #1130 3.9345059309125944E-13<>183.6125 #1140 4.0918861681490982E-13<>190.957 #1150 4.249266405385602E-13<>198.3015 #1160 4.4066466426221053E-13<>205.646 #1170 4.5640268798586096E-13<>212.9905 #1180 4.7214071170951134E-13<>220.335 #1190 4.8787873543316172E-13<>227.6795 #1200 5.03616759156812E-13<>235.024 #1210 5.1935478288046249E-13<>242.3685 #1220 5.3509280660411287E-13<>249.713 #1230 5.5083083032776305E-13<>257.0575 #1240 5.6656885405141353E-13<>264.402 #1250 5.8230687777506391E-13<>271.7465 #1260 5.9804490149871429E-13<>279.091 #1270 6.1378292522236457E-13<>286.4355 #1280 6.2952094894601496E-13<>293.78 #1290 6.4525897266966544E-13<>301.1245 #1300 6.6099699639331582E-13<>308.469 #1310 6.767350201169662E-13<>315.8135 #1320 6.9247304384061648E-13<>323.158 #1330 7.0821106756426696E-13<>330.5025 #1340 7.2394909128791724E-13<>337.847 #1350 7.3968711501156763E-13<>345.1915 #1360 7.5542513873521801E-13<>352.536 #1370 7.7116316245886839E-13<>359.8805 #1380 8.0263920990616925E-13<>374.5695 #1390 8.1837723362981963E-13<>381.914 #1400 8.3411525735347002E-13<>389.2585 #1410 8.498532810771204E-13<>396.603 #1420 8.6559130480077068E-13<>403.9475 #1430 8.8132932852442106E-13<>411.292 #1440 8.9706735224807144E-13<>418.6365 #1450 9.1280537597172192E-13<>425.981 #1460 9.285433996953723E-13<>433.3255 #1470 9.4428142341902269E-13<>440.67 #1480 9.6001944714267307E-13<>448.0145 #1490 9.7575747086632345E-13<>455.359 #1500 9.9149549458997363E-13<>462.7035 #1510 1.0072335183136242E-12<>470.048 #1520 1.0229715420372746E-12<>477.3925 #1530 1.038709565760925E-12<>484.737 #1540 1.0544475894845754E-12<>492.0815 #1550 1.0701856132082255E-12<>499.426 #1560 1.0859236369318759E-12<>506.7705 #1570 1.1016616606555263E-12<>514.115
#1580 1.1173996843791767E-12<>521.4595 #1590 1.1331377081028273E-12<>528.804 #1600 1.1488757318264774E-12<>536.1485 #1610 1.1646137555501278E-12<>543.493 #1620 1.1803517792737782E-12<>550.8375 #1630 1.1960898029974286E-12<>558.182 #1640 1.211827826721079E-12<>565.5265 #1650 1.2275658504447294E-12<>572.871 #1660 1.2433038741683795E-12<>580.2155 #1670 1.2590418978920299E-12<>587.56 #1680 1.2747799216156803E-12<>594.9045 #1690 1.2905179453393307E-12<>602.249 #1700 1.3062559690629812E-12<>609.5935 #1710 1.3219939927866316E-12<>616.938 #1720 1.337732016510282E-12<>624.2825 #1730 1.3534700402339324E-12<>631.627 #1740 1.3692080639575828E-12<>638.9715 #1750 1.3849460876812332E-12<>646.316 #1760 1.4006841114048835E-12<>653.6605 #1770 1.4164221351285339E-12<>661.005 #1780 1.4321601588521843E-12<>668.3495 #1790 1.4478981825758347E-12<>675.694 #1800 1.4636362062994851E-12<>683.0385 #1810 1.4793742300231354E-12<>690.383 #1820 1.4951122537467858E-12<>697.7275 #1830 1.5108502774704362E-12<>705.072 #1840 1.5265883011940866E-12<>712.4165 #1850 1.542326324917737E-12<>719.761 #1860 1.5580643486413874E-12<>727.1055 #1870 1.5738023723650375E-12<>734.45 #1881 8.1837723362981963E-13<>381.914 #1891 8.3411525735347002E-13<>389.2585 #1901 8.498532810771204E-13<>396.603 #1911 8.6559130480077068E-13<>403.9475 #1921 8.8132932852442106E-13<>411.292 #1931 8.9706735224807144E-13<>418.6365 #1941 9.1280537597172192E-13<>425.981 #1951 9.285433996953723E-13<>433.3255 #1961 9.4428142341902269E-13<>440.67 #1971 9.6001944714267307E-13<>448.0145 #1981 9.7575747086632345E-13<>455.359 #1991 9.9149549458997363E-13<>462.7035 #2002 1.5738023723650378E-14<>7.3445 #2011 3.1476047447300757E-14<>14.689 #2020 4.7214071170951138E-14<>22.0335 #2029 6.2952094894601513E-14<>29.378 #2038 7.8690118618251895E-14<>36.7225 #2047 9.4428142341902276E-14<>44.067 #2056 1.1016616606555263E-13<>51.4115 #2065 1.2590418978920303E-13<>58.756 #2074 1.4164221351285338E-13<>66.1005 #2083 1.5738023723650374E-13<>73.445 #2093 1.7311826096015412E-13<>80.7895 #2102 1.888562846838045E-13<>88.134 #2111 2.0459430840745491E-13<>95.4785 #2120 2.2033233213110526E-13<>102.823 #2129 2.3607035585475567E-13<>110.1675 #2138 2.51808379578406E-13<>117.512 #2147 2.6754640330205643E-13<>124.8565 #2156 2.8328442702570676E-13<>132.201 #2165 2.9902245074935715E-13<>139.5455 #2174 3.1476047447300748E-13<>146.89 #2184 1.5738023723650378E-14<>7.3445 #2193 1.5738023723650374E-13<>73.445 #2203 1.5738023723650375E-12<>734.45 #2213 1.7311826096015412E-13<>80.7895 #2223 1.888562846838045E-13<>88.134 #2233 2.0459430840745491E-13<>95.4785 #2243 2.2033233213110526E-13<>102.823 #2253 2.3607035585475567E-13<>110.1675 #2263 2.51808379578406E-13<>117.512 #2273 2.6754640330205643E-13<>124.8565 #2283 2.8328442702570676E-13<>132.201 #2293 2.9902245074935715E-13<>139.5455 #2303 3.1476047447300757E-14<>14.689 #2313 3.1476047447300748E-13<>146.89 #2323 3.3049849819665791E-13<>154.2345 #2333 3.4623652192030824E-13<>161.579 #2343 3.6197454564395862E-13<>168.9235 #2353 3.77712569367609E-13<>176.268 #2363 3.9345059309125944E-13<>183.6125 #2373 4.0918861681490982E-13<>190.957 #2383 4.249266405385602E-13<>198.3015 #2393 4.4066466426221053E-13<>205.646 #2403 4.5640268798586096E-13<>212.9905 #2413 4.7214071170951138E-14<>22.0335 #2423 4.7214071170951134E-13<>220.335 #2433 4.8787873543316172E-13<>227.6795 #2443 5.03616759156812E-13<>235.024 #2453 5.1935478288046249E-13<>242.3685 #2463 5.3509280660411287E-13<>249.713 #2473 5.5083083032776305E-13<>257.0575 #2483 5.6656885405141353E-13<>264.402 #2493 5.8230687777506391E-13<>271.7465 #2503 5.9804490149871429E-13<>279.091 #2513 6.1378292522236457E-13<>286.4355 #2523 6.2952094894601513E-14<>29.378 #2533 6.2952094894601496E-13<>293.78 #2543 6.4525897266966544E-13<>301.1245 #2553 6.6099699639331582E-13<>308.469 #2563 6.767350201169662E-13<>315.8135 #2573 6.9247304384061648E-13<>323.158 #2583 7.0821106756426696E-13<>330.5025 #2593 7.2394909128791724E-13<>337.847 #2603 7.3968711501156763E-13<>345.1915 #2613 7.5542513873521801E-13<>352.536 #2623 7.7116316245886839E-13<>359.8805
#2633 7.8690118618251895E-14<>36.7225 #2643 7.8690118618251887E-13<>367.225 #2653 8.0263920990616925E-13<>374.5695 #2663 8.1837723362981963E-13<>381.914 #2673 8.3411525735347002E-13<>389.2585 #2683 8.498532810771204E-13<>396.603 #2693 8.6559130480077068E-13<>403.9475 #2703 8.8132932852442106E-13<>411.292 #2713 8.9706735224807144E-13<>418.6365 #2723 9.1280537597172192E-13<>425.981 #2733 9.285433996953723E-13<>433.3255 #2743 9.4428142341902276E-14<>44.067 #2753 9.4428142341902269E-13<>440.67 #2763 9.6001944714267307E-13<>448.0145 #2773 9.7575747086632345E-13<>455.359 #2783 9.9149549458997363E-13<>462.7035 #2793 1.0072335183136242E-12<>470.048 #2803 1.0229715420372746E-12<>477.3925 #2813 1.038709565760925E-12<>484.737 #2823 1.0544475894845754E-12<>492.0815 #2833 1.0701856132082255E-12<>499.426 #2843 1.0859236369318759E-12<>506.7705 #2853 1.1016616606555263E-13<>51.4115 #2863 1.1016616606555263E-12<>514.115 #2873 1.1173996843791767E-12<>521.4595 #2883 1.1331377081028273E-12<>528.804 #2893 1.1488757318264774E-12<>536.1485 #2903 1.1646137555501278E-12<>543.493 #2913 1.1803517792737782E-12<>550.8375 #2923 1.1960898029974286E-12<>558.182 #2933 1.211827826721079E-12<>565.5265 #2943 1.2275658504447294E-12<>572.871 #2953 1.2433038741683795E-12<>580.2155 #2963 1.2590418978920303E-13<>58.756 #2973 1.2590418978920299E-12<>587.56 #2983 1.2747799216156803E-12<>594.9045 #2993 1.2905179453393307E-12<>602.249 #3003 1.3062559690629812E-12<>609.5935 #3013 1.3219939927866316E-12<>616.938 #3023 1.337732016510282E-12<>624.2825 #3033 1.3534700402339324E-12<>631.627 #3043 1.3692080639575828E-12<>638.9715 #3053 1.3849460876812332E-12<>646.316 #3063 1.4006841114048835E-12<>653.6605 #3073 1.4164221351285338E-13<>66.1005 #3083 1.4164221351285339E-12<>661.005 #3093 1.4321601588521843E-12<>668.3495 #3103 1.4478981825758347E-12<>675.694 #3113 1.4636362062994851E-12<>683.0385 #3123 1.4793742300231354E-12<>690.383 #3133 1.4951122537467858E-12<>697.7275 #3143 1.5108502774704362E-12<>705.072 #3153 1.5265883011940866E-12<>712.4165 #3163 1.542326324917737E-12<>719.761 #3173 1.5580643486413874E-12<>727.1055 #3185 1.5738023723650378E-14<>7.3445 #3195 1.5738023723650374E-13<>73.445 #3205 3.1476047447300748E-13<>146.89 #3215 1.0229715420372746E-12<>477.3925 #3225 1.1646137555501278E-12<>543.493 #3235 1.3219939927866316E-12<>616.938 #3246 1.5738023723650374E-13<>73.445 #3256 1.5738023723650374E-13<>73.445 #3266 3.1476047447300748E-13<>146.89 #3276 4.7214071170951134E-13<>220.335 #3286 1.1646137555501278E-12<>543.493 #3296 1.3219939927866316E-12<>616.938 #3307 1.3219939927866316E-12<>616.938 #3317 1.1646137555501278E-12<>543.493 #3327 6.2952094894601496E-13<>293.78 #3337 3.1476047447300748E-13<>146.89 #3347 1.5738023723650374E-13<>73.445 #3359 1.5738023723650378E-14<>7.3445 #3369 1.5738023723650374E-13<>73.445 #3379 1.7311826096015412E-13<>80.7895 #3389 1.888562846838045E-13<>88.134 #3399 2.0459430840745491E-13<>95.4785 #3409 2.2033233213110526E-13<>102.823 #3419 2.3607035585475567E-13<>110.1675 #3429 2.51808379578406E-13<>117.512 #3439 2.6754640330205643E-13<>124.8565 #3449 2.8328442702570676E-13<>132.201 #3459 2.9902245074935715E-13<>139.5455 #3469 1.5738023723650375E-12<>734.45 #3480 1.5738023723650378E-14<>7.3445 #3491 1.5738023723650378E-14<>7.3445 #3501 1.5738023723650374E-13<>73.445 #3511 1.7311826096015412E-13<>80.7895 #3521 1.888562846838045E-13<>88.134 #3531 2.0459430840745491E-13<>95.4785 #3541 2.2033233213110526E-13<>102.823 #3551 2.3607035585475567E-13<>110.1675 #3561 2.51808379578406E-13<>117.512 #3571 2.6754640330205643E-13<>124.8565 #3581 2.8328442702570676E-13<>132.201 #3591 2.9902245074935715E-13<>139.5455 #3601 1.5738023723650375E-12<>734.45 #3612 3.1476047447300757E-14<>14.689 #3622 4.7214071170951138E-14<>22.0335 #3632 6.2952094894601513E-14<>29.378 #3642 7.8690118618251895E-14<>36.7225 #3652 9.4428142341902276E-14<>44.067 #3662 1.1016616606555263E-13<>51.4115 #3672 1.2590418978920303E-13<>58.756 #3682 1.4164221351285338E-13<>66.1005 #3692 3.1476047447300748E-13<>146.89 #3702 3.3049849819665791E-13<>154.2345 #3712 3.4623652192030824E-13<>161.579 #3722 3.6197454564395862E-13<>168.9235 #3732 3.77712569367609E-13<>176.268 #3742 3.9345059309125944E-13<>183.6125 #3752 4.0918861681490982E-13<>190.957 #3762 4.249266405385602E-13<>198.3015 #3772 4.4066466426221053E-13<>205.646 #3782 4.5640268798586096E-13<>212.9905 #3792 4.7214071170951134E-13<>220.335 #3802 4.8787873543316172E-13<>227.6795 #3812 5.03616759156812E-13<>235.024 #3822 5.1935478288046249E-13<>242.3685 #3832 5.3509280660411287E-13<>249.713 #3842 5.5083083032776305E-13<>257.0575 #3852 5.6656885405141353E-13<>264.402 #3862 5.8230687777506391E-13<>271.7465 #3872 5.9804490149871429E-13<>279.091 #3882 6.1378292522236457E-13<>286.4355
#3892 6.2952094894601496E-13<>293.78 #3902 6.4525897266966544E-13<>301.1245 #3912 6.6099699639331582E-13<>308.469 #3922 6.767350201169662E-13<>315.8135 #3932 6.9247304384061648E-13<>323.158 #3942 7.0821106756426696E-13<>330.5025 #3952 7.2394909128791724E-13<>337.847 #3962 7.3968711501156763E-13<>345.1915 #3972 7.5542513873521801E-13<>352.536 #3982 7.7116316245886839E-13<>359.8805 #3992 7.8690118618251887E-13<>367.225 #4002 8.0263920990616925E-13<>374.5695 #4012 8.1837723362981963E-13<>381.914 #4022 8.3411525735347002E-13<>389.2585 #4032 8.498532810771204E-13<>396.603 #4042 8.6559130480077068E-13<>403.9475 #4052 8.8132932852442106E-13<>411.292 #4062 8.9706735224807144E-13<>418.6365 #4072 9.1280537597172192E-13<>425.981 #4082 9.285433996953723E-13<>433.3255 #4092 9.4428142341902269E-13<>440.67 #4102 9.6001944714267307E-13<>448.0145 #4112 9.7575747086632345E-13<>455.359 #4122 9.9149549458997363E-13<>462.7035 #4132 1.0072335183136242E-12<>470.048 #4142 1.0229715420372746E-12<>477.3925 #4152 1.038709565760925E-12<>484.737 #4162 1.0544475894845754E-12<>492.0815 #4172 1.0701856132082255E-12<>499.426 #4182 1.0859236369318759E-12<>506.7705 #4192 1.1016616606555263E-12<>514.115 #4202 1.1173996843791767E-12<>521.4595 #4212 1.1331377081028273E-12<>528.804 #4222 1.1488757318264774E-12<>536.1485 #4232 1.1646137555501278E-12<>543.493 #4242 1.1803517792737782E-12<>550.8375 #4252 1.1960898029974286E-12<>558.182 #4262 1.211827826721079E-12<>565.5265 #4272 1.2275658504447294E-12<>572.871 #4282 1.2433038741683795E-12<>580.2155 #4292 1.2590418978920299E-12<>587.56 #4302 1.2747799216156803E-12<>594.9045 #4312 1.2905179453393307E-12<>602.249 #4322 1.3062559690629812E-12<>609.5935 #4332 1.3219939927866316E-12<>616.938 #4342 1.337732016510282E-12<>624.2825 #4352 1.3534700402339324E-12<>631.627 #4362 1.3692080639575828E-12<>638.9715 #4372 1.3849460876812332E-12<>646.316 #4382 1.4006841114048835E-12<>653.6605 #4392 1.4164221351285339E-12<>661.005 #4402 1.4321601588521843E-12<>668.3495 #4412 1.4478981825758347E-12<>675.694 #4422 1.4636362062994851E-12<>683.0385 #4432 1.4793742300231354E-12<>690.383 #4442 1.4951122537467858E-12<>697.7275 #4452 1.5108502774704362E-12<>705.072 #4462 1.5265883011940866E-12<>712.4165 #4472 1.542326324917737E-12<>719.761
#4482 1.5580643486413874E-12<>727.1055 #4492 1.5738023723650374E-13<>73.445 #4500 ! ORM without acknowledge - Retrieve from SQL
! Exception EInvalidOp raised with messsage:
! Invalid floating point operation
#10 1.5738023723650378E-14<>7.3445 #19 3.1476047447300757E-14<>14.689 #28 4.7214071170951138E-14<>22.0335 #37 6.2952094894601513E-14<>29.378 #46 7.8690118618251895E-14<>36.7225 #55 9.4428142341902276E-14<>44.067 #64 1.1016616606555263E-13<>51.4115 #73 1.2590418978920303E-13<>58.756 #82 1.4164221351285338E-13<>66.1005 #91 1.5738023723650374E-13<>73.445 #100 1.7311826096015412E-13<>80.7895 #109 1.888562846838045E-13<>88.134 #118 2.0459430840745491E-13<>95.4785 #127 2.2033233213110526E-13<>102.823 #136 2.3607035585475567E-13<>110.1675 #145 2.51808379578406E-13<>117.512 #154 2.6754640330205643E-13<>124.8565 #163 2.8328442702570676E-13<>132.201 #172 2.9902245074935715E-13<>139.5455 #181 3.1476047447300748E-13<>146.89 #190 3.3049849819665791E-13<>154.2345 #199 3.4623652192030824E-13<>161.579 #208 3.6197454564395862E-13<>168.9235 #217 3.77712569367609E-13<>176.268 #226 3.9345059309125944E-13<>183.6125 #235 4.0918861681490982E-13<>190.957 #244 4.249266405385602E-13<>198.3015 #253 4.4066466426221053E-13<>205.646 #262 4.5640268798586096E-13<>212.9905 #271 4.7214071170951134E-13<>220.335 #280 4.8787873543316172E-13<>227.6795 #289 5.03616759156812E-13<>235.024 #298 5.1935478288046249E-13<>242.3685 #307 5.3509280660411287E-13<>249.713 #316 5.5083083032776305E-13<>257.0575 #325 5.6656885405141353E-13<>264.402 #334 5.8230687777506391E-13<>271.7465
#343 5.9804490149871429E-13<>279.091 #352 6.1378292522236457E-13<>286.4355 #361 6.2952094894601496E-13<>293.78 #370 6.4525897266966544E-13<>301.1245 #379 6.6099699639331582E-13<>308.469 #388 6.767350201169662E-13<>315.8135 #397 6.9247304384061648E-13<>323.158 #406 7.0821106756426696E-13<>330.5025 #415 7.2394909128791724E-13<>337.847 #424 7.3968711501156763E-13<>345.1915 #433 7.5542513873521801E-13<>352.536 #442 7.7116316245886829E-13<>359.8805 #451 7.8690118618251887E-13<>367.225 #460 8.0263920990616925E-13<>374.5695 #469 8.1837723362981963E-13<>381.914 #478 8.3411525735347002E-13<>389.2585 #487 8.498532810771204E-13<>396.603 #496 8.6559130480077068E-13<>403.9475 #505 8.8132932852442106E-13<>411.292 #514 8.9706735224807134E-13<>418.6365 #523 9.1280537597172192E-13<>425.981 #532 9.285433996953723E-13<>433.3255 #541 9.4428142341902269E-13<>440.67 #550 9.6001944714267307E-13<>448.0145 #559 9.7575747086632345E-13<>455.359 #568 9.9149549458997363E-13<>462.7035 #577 1.0072335183136242E-12<>470.048 #586 1.0229715420372746E-12<>477.3925 #595 1.038709565760925E-12<>484.737 #604 1.0544475894845754E-12<>492.0815 #613 1.0701856132082255E-12<>499.426 #622 1.0859236369318759E-12<>506.7705 #631 1.1016616606555263E-12<>514.115 #640 1.1173996843791767E-12<>521.4595 #649 1.1331377081028273E-12<>528.804 #658 1.1488757318264774E-12<>536.1485 #667 1.1646137555501278E-12<>543.493 #676 1.1803517792737782E-12<>550.8375 #685 1.1960898029974286E-12<>558.182 #694 1.211827826721079E-12<>565.5265 #703 1.2275658504447294E-12<>572.871 #712 1.2433038741683795E-12<>580.2155 #721 1.2590418978920299E-12<>587.56 #730 1.2747799216156803E-12<>594.9045 #739 1.2905179453393307E-12<>602.249 #748 1.3062559690629812E-12<>609.5935 #757 1.3219939927866316E-12<>616.938 #766 1.337732016510282E-12<>624.2825 #775 1.3534700402339324E-12<>631.627 #784 1.3692080639575828E-12<>638.9715 #793 1.3849460876812332E-12<>646.316 #802 1.4006841114048835E-12<>653.6605 #811 1.4164221351285339E-12<>661.005 #820 1.4321601588521843E-12<>668.3495 #829 1.4478981825758347E-12<>675.694 #838 1.4636362062994851E-12<>683.0385 #847 1.4793742300231354E-12<>690.383 #856 1.4951122537467858E-12<>697.7275 #865 1.5108502774704362E-12<>705.072 #874 1.5265883011940866E-12<>712.4165 #883 1.542326324917737E-12<>719.761 #892 1.5580643486413874E-12<>727.1055 #901 1.5738023723650375E-12<>734.45 ! - Update: 100 / 902 FAILED 15.18ms
100 rows updated in 4.39ms i.e. 22,737/s, aver. 43us, 3.9 MB/s
#109 1.5738023723650378E-14<>7.3445 #120 3.1476047447300757E-14<>14.689 #131 4.7214071170951138E-14<>22.0335 #142 6.2952094894601513E-14<>29.378 #153 7.8690118618251895E-14<>36.7225 #164 9.4428142341902276E-14<>44.067 #175 1.1016616606555263E-13<>51.4115 #186 1.2590418978920303E-13<>58.756 #197 1.4164221351285338E-13<>66.1005 #208 1.5738023723650374E-13<>73.445 #219 1.7311826096015412E-13<>80.7895 #230 1.888562846838045E-13<>88.134 #241 2.0459430840745491E-13<>95.4785 #252 2.2033233213110526E-13<>102.823 #263 2.3607035585475567E-13<>110.1675 #274 2.51808379578406E-13<>117.512 #285 2.6754640330205643E-13<>124.8565 #296 2.8328442702570676E-13<>132.201 #307 2.9902245074935715E-13<>139.5455 #318 3.1476047447300748E-13<>146.89 #329 3.3049849819665791E-13<>154.2345 #340 3.4623652192030824E-13<>161.579 #351 3.6197454564395862E-13<>168.9235 #362 3.77712569367609E-13<>176.268 #373 3.9345059309125944E-13<>183.6125 #384 4.0918861681490982E-13<>190.957 #395 4.249266405385602E-13<>198.3015 #406 4.4066466426221053E-13<>205.646 #417 4.5640268798586096E-13<>212.9905 #428 4.7214071170951134E-13<>220.335 #439 4.8787873543316172E-13<>227.6795 #450 5.03616759156812E-13<>235.024 #461 5.1935478288046249E-13<>242.3685 #472 5.3509280660411287E-13<>249.713 #483 5.5083083032776305E-13<>257.0575 #494 5.6656885405141353E-13<>264.402 #505 5.8230687777506391E-13<>271.7465 #516 5.9804490149871429E-13<>279.091 #527 6.1378292522236457E-13<>286.4355 #538 6.2952094894601496E-13<>293.78 #549 6.4525897266966544E-13<>301.1245 #560 6.6099699639331582E-13<>308.469 #571 6.767350201169662E-13<>315.8135 #582 6.9247304384061648E-13<>323.158 #593 7.0821106756426696E-13<>330.5025 #604 7.2394909128791724E-13<>337.847 #615 7.3968711501156763E-13<>345.1915 #626 7.5542513873521801E-13<>352.536 #637 7.7116316245886829E-13<>359.8805 #648 7.8690118618251887E-13<>367.225 #659 8.0263920990616925E-13<>374.5695 #670 8.1837723362981963E-13<>381.914 #681 8.3411525735347002E-13<>389.2585 #692 8.498532810771204E-13<>396.603 #703 8.6559130480077068E-13<>403.9475 #714 8.8132932852442106E-13<>411.292 #725 8.9706735224807134E-13<>418.6365 #736 9.1280537597172192E-13<>425.981 #747 9.285433996953723E-13<>433.3255 #758 9.4428142341902269E-13<>440.67 #769 9.6001944714267307E-13<>448.0145
#780 9.7575747086632345E-13<>455.359 #791 9.9149549458997363E-13<>462.7035 #802 1.0072335183136242E-12<>470.048 #813 1.0229715420372746E-12<>477.3925 #824 1.038709565760925E-12<>484.737 #835 1.0544475894845754E-12<>492.0815
#846 1.0701856132082255E-12<>499.426 #857 1.0859236369318759E-12<>506.7705 #868 1.1016616606555263E-12<>514.115 #879 1.1173996843791767E-12<>521.4595 #890 1.1331377081028273E-12<>528.804 #901 1.1488757318264774E-12<>536.1485 #912 1.1646137555501278E-12<>543.493 #923 1.1803517792737782E-12<>550.8375 #934 1.1960898029974286E-12<>558.182 #945 1.211827826721079E-12<>565.5265 #956 1.2275658504447294E-12<>572.871 #967 1.2433038741683795E-12<>580.2155 #978 1.2590418978920299E-12<>587.56 #989 1.2747799216156803E-12<>594.9045 #1000 1.2905179453393307E-12<>602.249 #1011 1.3062559690629812E-12<>609.5935 #1022 1.3219939927866316E-12<>616.938 #1033 1.337732016510282E-12<>624.2825 #1044 1.3534700402339324E-12<>631.627 #1055 1.3692080639575828E-12<>638.9715 #1066 1.3849460876812332E-12<>646.316 #1077 1.4006841114048835E-12<>653.6605 #1088 1.4164221351285339E-12<>661.005 #1099 1.4321601588521843E-12<>668.3495
#1110 1.4478981825758347E-12<>675.694 #1121 1.4636362062994851E-12<>683.0385 #1132 1.4793742300231354E-12<>690.383 #1143 1.4951122537467858E-12<>697.7275 #1154 1.5108502774704362E-12<>705.072 #1165 1.5265883011940866E-12<>712.4165 #1176 1.542326324917737E-12<>719.761 #1187 1.5580643486413874E-12<>727.1055 #1198 1.5738023723650375E-12<>734.45 #1511 1.5738023723650378E-14<>7.3445 #1523 3.1476047447300757E-14<>14.689 #1535 4.7214071170951138E-14<>22.0335 #1547 6.2952094894601513E-14<>29.378 #1559 7.8690118618251895E-14<>36.7225 #1571 9.4428142341902276E-14<>44.067 #1583 1.1016616606555263E-13<>51.4115 #1595 1.2590418978920303E-13<>58.756 #1607 1.4164221351285338E-13<>66.1005 #1619 1.5738023723650374E-13<>73.445 #1631 1.7311826096015412E-13<>80.7895 #1643 1.888562846838045E-13<>88.134 #1655 2.0459430840745491E-13<>95.4785 #1667 2.2033233213110526E-13<>102.823 #1679 2.3607035585475567E-13<>110.1675 #1691 2.51808379578406E-13<>117.512 #1703 2.6754640330205643E-13<>124.8565 #1715 2.8328442702570676E-13<>132.201 #1727 2.9902245074935715E-13<>139.5455 #1739 3.1476047447300748E-13<>146.89 #1751 3.3049849819665791E-13<>154.2345 #1763 3.4623652192030824E-13<>161.579 #1775 3.6197454564395862E-13<>168.9235 #1787 3.77712569367609E-13<>176.268 #1799 3.9345059309125944E-13<>183.6125 #1811 4.0918861681490982E-13<>190.957 #1823 4.249266405385602E-13<>198.3015 #1835 4.4066466426221053E-13<>205.646 #1847 4.5640268798586096E-13<>212.9905 #1859 4.7214071170951134E-13<>220.335 #1871 4.8787873543316172E-13<>227.6795 #1883 5.03616759156812E-13<>235.024 #1895 5.1935478288046249E-13<>242.3685 #1907 5.3509280660411287E-13<>249.713 #1919 5.5083083032776305E-13<>257.0575 #1931 5.6656885405141353E-13<>264.402 #1943 5.8230687777506391E-13<>271.7465 #1955 5.9804490149871429E-13<>279.091 #1967 6.1378292522236457E-13<>286.4355 #1979 6.2952094894601496E-13<>293.78 #1991 6.4525897266966544E-13<>301.1245 #2003 6.6099699639331582E-13<>308.469 #2015 6.767350201169662E-13<>315.8135 #2027 6.9247304384061648E-13<>323.158 #2039 7.0821106756426696E-13<>330.5025 #2051 7.2394909128791724E-13<>337.847 #2063 7.3968711501156763E-13<>345.1915 #2075 7.5542513873521801E-13<>352.536 #2087 7.7116316245886829E-13<>359.8805 #2099 7.8690118618251887E-13<>367.225 #2111 8.0263920990616925E-13<>374.5695 #2123 8.1837723362981963E-13<>381.914 #2135 8.3411525735347002E-13<>389.2585 #2147 8.498532810771204E-13<>396.603 #2159 8.6559130480077068E-13<>403.9475 #2171 8.8132932852442106E-13<>411.292 #2183 8.9706735224807134E-13<>418.6365 #2195 9.1280537597172192E-13<>425.981 #2207 9.285433996953723E-13<>433.3255 #2219 9.4428142341902269E-13<>440.67 #2231 9.6001944714267307E-13<>448.0145 #2243 9.7575747086632345E-13<>455.359 #2255 9.9149549458997363E-13<>462.7035 #2267 1.0072335183136242E-12<>470.048 #2279 1.0229715420372746E-12<>477.3925 #2291 1.038709565760925E-12<>484.737 #2303 1.0544475894845754E-12<>492.0815 #2315 1.0701856132082255E-12<>499.426 #2327 1.0859236369318759E-12<>506.7705 #2339 1.1016616606555263E-12<>514.115 #2351 1.1173996843791767E-12<>521.4595 #2363 1.1331377081028273E-12<>528.804 #2375 1.1488757318264774E-12<>536.1485 #2387 1.1646137555501278E-12<>543.493
#2399 1.1803517792737782E-12<>550.8375 #2411 1.1960898029974286E-12<>558.182 #2423 1.211827826721079E-12<>565.5265 #2435 1.2275658504447294E-12<>572.871 #2447 1.2433038741683795E-12<>580.2155 #2459 1.2590418978920299E-12<>587.56 #2471 1.2747799216156803E-12<>594.9045 #2483 1.2905179453393307E-12<>602.249 #2495 1.3062559690629812E-12<>609.5935 #2507 1.3219939927866316E-12<>616.938 #2519 1.337732016510282E-12<>624.2825 #2531 1.3534700402339324E-12<>631.627 #2543 1.3692080639575828E-12<>638.9715 #2555 1.3849460876812332E-12<>646.316 #2567 1.4006841114048835E-12<>653.6605 #2579 1.4164221351285339E-12<>661.005 #2591 1.4321601588521843E-12<>668.3495 #2603 1.4478981825758347E-12<>675.694 #2615 1.4636362062994851E-12<>683.0385 #2627 1.4793742300231354E-12<>690.383 #2639 1.4951122537467858E-12<>697.7275 #2651 1.5108502774704362E-12<>705.072 #2663 1.5265883011940866E-12<>712.4165 #2675 1.542326324917737E-12<>719.761 #2687 1.5580643486413874E-12<>727.1055 #2699 1.5738023723650375E-12<>734.45 ! - Blobs: 200 / 2,707 FAILED 52.76ms
100 rows updated in 1.38ms i.e. 72,463/s, aver. 13us, 6 MB/s
#27 1.5738023723650378E-14<>7.3445 #36 3.1476047447300757E-14<>14.689 #45 4.7214071170951138E-14<>22.0335 #54 6.2952094894601513E-14<>29.378 #63 9.4428142341902276E-14<>44.067 #72 1.1016616606555263E-13<>51.4115 #81 1.2590418978920303E-13<>58.756 #90 1.4164221351285338E-13<>66.1005 #99 1.7311826096015412E-13<>80.7895 #108 1.888562846838045E-13<>88.134 #117 2.0459430840745491E-13<>95.4785 #126 2.2033233213110526E-13<>102.823 #135 2.51808379578406E-13<>117.512 #144 2.6754640330205643E-13<>124.8565 #153 2.8328442702570676E-13<>132.201 #162 2.9902245074935715E-13<>139.5455 #171 3.3049849819665791E-13<>154.2345 #180 3.4623652192030824E-13<>161.579 #189 3.6197454564395862E-13<>168.9235 #198 3.77712569367609E-13<>176.268 #207 4.0918861681490982E-13<>190.957 #216 4.249266405385602E-13<>198.3015 #225 4.4066466426221053E-13<>205.646 #234 4.5640268798586096E-13<>212.9905 #243 4.8787873543316172E-13<>227.6795 #252 5.03616759156812E-13<>235.024 #261 5.1935478288046249E-13<>242.3685 #270 5.3509280660411287E-13<>249.713 #279 5.6656885405141353E-13<>264.402 #288 5.8230687777506391E-13<>271.7465 #297 5.9804490149871429E-13<>279.091 #306 6.1378292522236457E-13<>286.4355 #315 6.4525897266966544E-13<>301.1245 #324 6.6099699639331582E-13<>308.469 #333 6.767350201169662E-13<>315.8135 #342 6.9247304384061648E-13<>323.158 #351 7.2394909128791724E-13<>337.847
#360 7.3968711501156763E-13<>345.1915 #369 7.5542513873521801E-13<>352.536 #378 7.7116316245886829E-13<>359.8805 #387 8.0263920990616925E-13<>374.5695 #396 8.1837723362981963E-13<>381.914 #405 8.3411525735347002E-13<>389.2585
#414 8.498532810771204E-13<>396.603 #423 8.8132932852442106E-13<>411.292 #432 8.9706735224807134E-13<>418.6365 #441 9.1280537597172192E-13<>425.981 #450 9.285433996953723E-13<>433.3255 #459 9.6001944714267307E-13<>448.0145
#468 9.7575747086632345E-13<>455.359 #477 9.9149549458997363E-13<>462.7035 #486 1.0072335183136242E-12<>470.048 #495 1.038709565760925E-12<>484.737 #504 1.0544475894845754E-12<>492.0815 #513 1.0701856132082255E-12<>499.426 #522 1.0859236369318759E-12<>506.7705 #531 1.1173996843791767E-12<>521.4595 #540 1.1331377081028273E-12<>528.804 #549 1.1488757318264774E-12<>536.1485 #558 1.1646137555501278E-12<>543.493 #567 1.1960898029974286E-12<>558.182 #576 1.211827826721079E-12<>565.5265 #585 1.2275658504447294E-12<>572.871 #594 1.2433038741683795E-12<>580.2155 #603 1.2747799216156803E-12<>594.9045 #612 1.2905179453393307E-12<>602.249 #621 1.3062559690629812E-12<>609.5935 #630 1.3219939927866316E-12<>616.938 #639 1.3534700402339324E-12<>631.627 #648 1.3692080639575828E-12<>638.9715 #657 1.3849460876812332E-12<>646.316 #666 1.4006841114048835E-12<>653.6605 #675 1.4321601588521843E-12<>668.3495 #684 1.4478981825758347E-12<>675.694 #693 1.4636362062994851E-12<>683.0385 #702 1.4793742300231354E-12<>690.383 #711 1.5108502774704362E-12<>705.072 #720 1.5265883011940866E-12<>712.4165 #729 1.542326324917737E-12<>719.761 #738 1.5580643486413874E-12<>727.1055 ! - Delete: 80 / 843 FAILED 35.18ms
20 rows deleted in 242us i.e. 82,644/s, aver. 12us, 3.4 MB/s
#31 1.5738023723650378E-14<>7.3445 #40 3.1476047447300757E-14<>14.689 #49 4.7214071170951138E-14<>22.0335 #58 6.2952094894601513E-14<>29.378 #67 9.4428142341902276E-14<>44.067 #76 1.1016616606555263E-13<>51.4115 #85 1.2590418978920303E-13<>58.756 #94 1.4164221351285338E-13<>66.1005 #103 1.7311826096015412E-13<>80.7895 #112 1.888562846838045E-13<>88.134 #121 2.0459430840745491E-13<>95.4785 #130 2.2033233213110526E-13<>102.823 #139 2.51808379578406E-13<>117.512 #148 2.6754640330205643E-13<>124.8565 #157 2.8328442702570676E-13<>132.201 #166 2.9902245074935715E-13<>139.5455 #175 3.3049849819665791E-13<>154.2345 #184 3.4623652192030824E-13<>161.579 #193 3.6197454564395862E-13<>168.9235 #202 3.77712569367609E-13<>176.268 #211 4.0918861681490982E-13<>190.957 #220 4.249266405385602E-13<>198.3015 #229 4.4066466426221053E-13<>205.646 #238 4.5640268798586096E-13<>212.9905 #247 4.8787873543316172E-13<>227.6795 #256 5.03616759156812E-13<>235.024 #265 5.1935478288046249E-13<>242.3685 #274 5.3509280660411287E-13<>249.713 #283 5.6656885405141353E-13<>264.402 #292 5.8230687777506391E-13<>271.7465 #301 5.9804490149871429E-13<>279.091 #310 6.1378292522236457E-13<>286.4355 #319 6.4525897266966544E-13<>301.1245 #328 6.6099699639331582E-13<>308.469 #337 6.767350201169662E-13<>315.8135 #346 6.9247304384061648E-13<>323.158 #355 7.2394909128791724E-13<>337.847 #364 7.3968711501156763E-13<>345.1915 #373 7.5542513873521801E-13<>352.536 #382 7.7116316245886839E-13<>359.8805 #391 8.0263920990616925E-13<>374.5695 #400 8.1837723362981963E-13<>381.914 #409 8.3411525735347002E-13<>389.2585 #418 8.498532810771204E-13<>396.603 #427 8.8132932852442106E-13<>411.292 #436 8.9706735224807144E-13<>418.6365 #445 9.1280537597172192E-13<>425.981 #454 9.285433996953723E-13<>433.3255 #463 9.6001944714267307E-13<>448.0145
#472 9.7575747086632345E-13<>455.359 #481 9.9149549458997363E-13<>462.7035 #490 1.0072335183136242E-12<>470.048 #499 1.038709565760925E-12<>484.737 #508 1.0544475894845754E-12<>492.0815 #517 1.0701856132082255E-12<>499.426 #526 1.0859236369318759E-12<>506.7705 #535 1.1173996843791767E-12<>521.4595 #544 1.1331377081028273E-12<>528.804 #553 1.1488757318264774E-12<>536.1485 #562 1.1646137555501278E-12<>543.493 #571 1.1960898029974286E-12<>558.182 #580 1.211827826721079E-12<>565.5265 #589 1.2275658504447294E-12<>572.871 #598 1.2433038741683795E-12<>580.2155 #607 1.2747799216156803E-12<>594.9045 #616 1.2905179453393307E-12<>602.249 #625 1.3062559690629812E-12<>609.5935 #634 1.3219939927866316E-12<>616.938 #643 1.3534700402339324E-12<>631.627 #652 1.3692080639575828E-12<>638.9715 #661 1.3849460876812332E-12<>646.316 #670 1.4006841114048835E-12<>653.6605 #679 1.4321601588521843E-12<>668.3495 #688 1.4478981825758347E-12<>675.694 #697 1.4636362062994851E-12<>683.0385 #706 1.4793742300231354E-12<>690.383 #715 1.5108502774704362E-12<>705.072 #724 1.5265883011940866E-12<>712.4165 #733 1.542326324917737E-12<>719.761 #742 1.5580643486413874E-12<>727.1055 ! - Delete in batch mode: 80 / 743 FAILED 3.25ms
20 rows deleted in 108us i.e. 185,185/s, aver. 5us, 1.8 MB/s
Total failed: 1,211 / 12,809 - ORM without acknowledge FAILED 346.02ms
Using MongoDB 4.2.9 mozjs biggie,wiredTiger
Running on Ubuntu 20.04.1 LTS - Linux 5.4.0-42-generic
Compiled with mORMot 1.18.6124
Generated with: Free Pascal 3.2 64 bit compiler
Time elapsed for all tests: 1.38s
Performed 2020-08-27 20:39:32 by koray on ubuntu-vm
Total assertions failed for all test suits: 2,422 / 28,002
! Some tests FAILED: please correct the code.Our mongodb and ubuntu versions are different. I don't think it's because of linux version, most likely mongodb version is the problem but to be sure i will upgrade it.