Enhancement
Use package to speed up modifications through the API
Issue description
A POST service using the Tobject API for inserting, changing and deleting data is currently slow because every SQL statement is processed individually. It would be a great improvement, if the the modifying statements would be converted to a package and imported through that mechanism which is much more efficient and faster.
Developer comments
This could be tested best with the methodology used in the switch from tmdm to fast tmdm. Run the test with the fragmented sql and with the bulk sql. Compare the results.
The dobject contains statement identifiers, that is very good as it will allow to construct the package.
The idea here is to avoid the locks by simply reducing the db modification to a minimum at the end of the request. Package is perfect for that plus it saves it to a journal. This seems to be working ok despite the difficult changes. So far tempoary ids were only created on the client, now they are created on the server as well, but only for a short period of time within the PHP process. Temporary ids on the server, for all item, not only topics, are negative integers, starting with -1. The dobject plays a major part in the implementation as it acts as the central point for all uncommitted information on a topic. This is perfect as it is also the data cache for the topic.
This is implemented now and in production in selected systems. Not standard behavior yet.
|
Work sessions15
Start |
2022-12-27T08:00:00
|
End |
2022-12-27T11:30:00
|
Participant |
Robert Cerny
|
Start |
2022-12-27T12:20:00
|
End |
2022-12-27T13:14:29
|
Participant |
Robert Cerny
|
Start |
2022-12-27T15:42:40
|
End |
2022-12-27T16:42:51
|
Participant |
Robert Cerny
|
Start |
2022-12-27T19:18:11
|
End |
2022-12-27T21:20:16
|
Participant |
Robert Cerny
|
Start |
2022-12-28T07:41:11
|
End |
2022-12-28T11:30:00
|
Participant |
Robert Cerny
|
Start |
2022-12-28T13:00:00
|
End |
2022-12-28T13:31:12
|
Participant |
Robert Cerny
|
Start |
2022-12-28T14:06:06
|
End |
2022-12-28T16:30:04
|
Participant |
Robert Cerny
|
Start |
2022-12-28T17:36:47
|
End |
2022-12-28T18:16:18
|
Participant |
Robert Cerny
|
Start |
2022-12-28T18:30:00
|
End |
2022-12-28T19:55:02
|
Participant |
Robert Cerny
|
Start |
2022-12-29T07:26:08
|
End |
2022-12-29T08:10:22
|
Participant |
Robert Cerny
|
Start |
2022-12-29T09:30:00
|
End |
2022-12-29T11:49:56
|
Participant |
Robert Cerny
|
Start |
2022-12-29T13:00:39
|
End |
2022-12-29T17:13:33
|
Participant |
Robert Cerny
|
Start |
2022-12-29T20:00:00
|
End |
2022-12-29T21:46:24
|
Participant |
Robert Cerny
|
Start |
2022-12-30T06:30:38
|
End |
2022-12-30T08:13:50
|
Participant |
Robert Cerny
|
Start |
2022-12-31T12:00:00
|
End |
2022-12-31T13:24:52
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.