Some expert in MySQL!!!

Sarah Wesker · May 26, 2018

what difference there is between these 2 functions.

Code:

      luaDatabaseExecute

Code:

      luaDatabaseAsyncExecute

The one who does not know anything about this that better not write anything.
a little doubt

(db.query) return boolean value
(AsyncExecute) return ???

Bogart · May 27, 2018

Asynchronous vs synchronous execution, what does it really mean?

Sarah Wesker · May 27, 2018

then you should not use (Asyn)
Example:

Code:

local result_ptr = db.asyncQuery("UPDATE `xtable` SET `time` = " .. time .. " WHERE `id` = 1;")
if not result_ptr then
return false
end

What is the best ?

Code:

local result_ptr = db.query("UPDATE `xtable` SET `time` = " .. time .. " WHERE `id` = 1;")
if not result_ptr then
return false
end

slaw · May 28, 2018

Async doesn't block the main thread, so for UPDATE or INSERT queries, I would recommend it.

For "SELECT" queries you should be using anyways a normal variant, as you need to have the result immediately, not in the background (async).

This is just my opinion.

Sarah Wesker · May 28, 2018

slawkens said:
Async doesn't block the main thread, so for UPDATE or INSERT queries, I would recommend it.

For "SELECT" queries you should be using anyways a normal variant, as you need to have the result immediately, not in the background (async).

This is just my opinion.

Thank you very much, my friend

Some expert in MySQL!!!

Sarah Wesker

ƐƖєgαηт Sуηтαx ❤

Bogart

...has super panda powers

Sarah Wesker

ƐƖєgαηт Sуηтαx ❤

slaw

Software Developer

Sarah Wesker

ƐƖєgαηт Sуηтαx ❤

Similar threads