2022.12.06 05:35 AM
I'm use KxSystems/javakdb with commons-pool2.
Is the connection pool meaningless because KDB+ is a single thread?
Is it better to connect a TCP session when a request is required?
Is there any advantage in using Flip in Java rather than .j.j when processing function results?
I'm sorry I have many questions.
2022.12.07 06:51 AM - edited 2022.12.07 06:57 AM
One item to note is that .j.j will put processing load on to the kdb+ process.
JSON also only has a limited set of datatypes which means you will need to write more q code to perform parsing/casting
Using the c.flip distributes the serialisation work across your java processes/threads and minimizes the work kdb+ will have to do to deserialise/parse/cast.
kdb+ does have a multithreaded input queue mode (but it does have restrictions)
2022.12.07 07:21 AM
but I won't use multithreaded input mode because many restrictions. kdb is fast enough, there is an advantage of single thread.
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.