15.08.2018 17:28, Alex Peshkoff via Firebird-devel wrote:
For single request no boost, but when we talk about server under high load serving
multiple requests performance boost will be present.
What could cause it given that I/O is already parallelized by storage system?
"Very big people" should consider horizontal scaling in addition to pushing
into vertical.
In theory I can agree, on practice...
On practice we have this:
Statement 589:
-------------------------------------------------------------------------------
INSERT INTO
"XQS_2100_3300"("ID","DOC_ID","WARE_ID","SND_OPTYPE_ID","SND_ID","SND_QTY","RCV_DOC_ID","RCV_OPTYPE_ID","RCV_ID","RCV_QTY","SND_PURCHASE","SND_RETAIL","R
CV_PURCHASE","RCV_RETAIL","TRN_ID","DTS") VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
param0 = bigint, "233598700"
param1 = bigint, "814011215"
param2 = bigint, "234"
param3 = smallint, "2100"
param4 = bigint, "110712406"
param5 = bigint(*, -3), "1.000"
param6 = bigint, "858691363"
param7 = smallint, "3300"
param8 = bigint, "116899825"
param9 = bigint(*, -3), "<NULL>"
param10 = bigint(*, -2), "1600.00"
param11 = bigint(*, -2), "2600.00"
param12 = bigint(*, -2), "<NULL>"
param13 = bigint(*, -2), "<NULL>"
param14 = bigint, "1680348"
param15 = timestamp, "2018-08-10T10:47:46.7290"
0 records fetched
1008 ms, 32 fetch(es), 17 mark(s)
Table Natural Index Update Insert
Delete Backout Purge Expunge
***************************************************************************************************************
XQS_2100_3300 1
And I hell wonder why simple insert can take whole second.
--
WBR, SD.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel