Sqlexecute async

[Mauricio_Pulla]

There are several techniques to upload data.

Personally I use JSON.
I have had to send 1600,000 records to the postgresql server, I put together the json (50 - 60 thousand records at a time) and pass it to a function, it receives it and inserts it into the table, the process on the server side is very fast.

When I have many records I use Copy which is much faster.
COPY public.data_load FROM ‘/path/data_migra.csv’ DELIMITER ‘,’ CSV HEADER;

If I’m not wrong in mysql LOAD DATA LOCAL INFILE

Greetings
Mauricio

[jury_buono1 (jury buono)]

I can’t because the socket server and mysql server Is not the same machine

[Greg_O]

@jury_buono1

Is there the possibility (with xojo code ) to intercept how many cpu and relative cores there Ares on the machine where run the app ?

To set the cores of worker at runtime

That’s the whole point of the percentages. If you only want to use 3 out of 4 cores, use 75%.

You should also do some tests for diminishing returns, that is, whether more cores is always better. There is always some overhead when using workers and if the start up and tear down take longer than the operation itself, you might as well just use fewer cores and send them to an existing worker.