Activity

Artur Școlnic's activity

From 05/28/2025 to 06/26/2025

08:06 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I want this to also be documented in case the discussion about using one connection in a multithreaded environment ar... Artur Școlnic
07:29 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I want to document on the task what exactly could the async 'for each' achieve and when it is especially beneficial.
... Artur Școlnic

10:28 AM Database Feature #10169: result-set streaming (and asynchronous programming?): To answer Alexandru's questions, the JDBC driver does not allow for concurrent result set traversal within a single ... Artur Școlnic
05:33 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I also think we can determine if the queries in the for each alter the iterated table, if not, enable async, but crea... Artur Școlnic
05:26 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I think I have hit a wall with the current approach. When you're using the same JDBC Connection and have an open Resu... Artur Școlnic

07:26 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Ok, I revised the code, indeed I am creating one thread each time a @for each@ is called and leaking threads, but jus... Artur Școlnic
07:05 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Ovidiu Maxiniuc wrote:
> But when FWD decided the code from a client requires a background execution, the context is... Artur Școlnic
05:42 AM Database Feature #10169: result-set streaming (and asynchronous programming?): My goal is to delegate as much work as possible to the secondary thread, ideally the whole @query.next@, this include... Artur Școlnic
03:22 AM Database Feature #10169: result-set streaming (and asynchronous programming?): !async_for_each.png!
Each line is a result set access for a given thread, but the connection is shared, so the acc... Artur Școlnic
03:00 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Artur Școlnic wrote:
> we will need to synchronize the access to the result sets so that there is no overlap.
I ... Artur Școlnic
02:31 AM Database Feature #10169: result-set streaming (and asynchronous programming?): After a quick investigation, I found out that most JDBC drivers support multiple opened result sets on a single conne... Artur Școlnic

10:11 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Alexandru Lungu wrote:
> But with an implementation of async fetching, you may end up gathering record 100.000th and... Artur Școlnic
08:40 AM Database Feature #10169: result-set streaming (and asynchronous programming?): At the meeting, Alexandru raised a valid concern regarding the async execution for the foreach query. In my initial i... Artur Școlnic

10:46 AM Database Feature #10169: result-set streaming (and asynchronous programming?): The java test cases show that the benefit of running the query in a separate thread is similar with running the busin... Artur Școlnic
08:02 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Well, this changes things. If the for each body cannot be executed in a new thread, I will go the other way and try t... Artur Școlnic
07:46 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Artur Școlnic wrote:
> I attached the source for this test.
Artur Școlnic
07:44 AM Database Feature #10169: result-set streaming (and asynchronous programming?): Artur Școlnic wrote:
> I started working on introducing async in @forEachWorker@, currently there are issues with ou... Artur Școlnic
07:35 AM Database Feature #10169: result-set streaming (and asynchronous programming?): On another note, I found a way to introduce artificial latency on a network adapter.
The delay is per tcp packet, ... Artur Școlnic
07:32 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I believe another way to utilize the result set streaming and async programming is streaming results in a for each wh... Artur Școlnic

06:07 AM Database Feature #10169: result-set streaming (and asynchronous programming?): I think this implies tracking and storing the time of execution for queries and iterative blocks that have queries (a... Artur Școlnic
04:59 AM Database Feature #10169 (WIP): result-set streaming (and asynchronous programming?): Below you can find the result of testing async execution for db queries combined with result set streaming.
To simul... Artur Școlnic

11:16 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: There are 153 more files in the baseline and 3 files differ compared to 10004a, which is the same as trunk. I suspect... Artur Școlnic
10:45 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: This explains my issues running the tests as junit :)
I compared the output binary files from trunk and 10004a, they... Artur Școlnic
09:54 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: Greg Shah wrote:
> The @library_calls/@ tests in [[p2j:Testcases]] should be executed. These are not yet reworked a... Artur Școlnic
06:23 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: Constantin Asofiei wrote:
> Do you have some other p2j.jar somewhere?
Just one in the deploy\lib
Artur Școlnic
05:44 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: @./junit.sh -c library_calls.TestRunner@... Artur Școlnic
04:38 AM Base Language Bug #10004: NativeInvoker fails if an argument is of type integerConstant: I have some issues running library_calls tests, is there a customer test suite that would be appropriate for testing? Artur Școlnic

Also available in: Atom