simultaneous sql transations

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 25, 2011

• #2

The SQL implementation is thread-safe. Writing and reading from multiple threads should be fine.
Still there are cases that it will be easier to manage the access to the db yourself.

BTW, what is your reason for using multiple threads?

 

Upvote 0

G

gorelshv

Member

Licensed User

Longtime User

• Mar 25, 2011

• #3

I am writing a server-like app which is devided into rooms, each room is represented by a table and is handled with it's own thread. This got me intrested to know what happens if a DB is accessed simultaneously at higher levels (DB) and lower levels (table, row, etc.).
I would like to know how b4a handles such cases.
BTW, when you say the implementation is thread-safe you mean that you (creators of b4a) took care of it when developing b4a?

 

Upvote 0

agraham

Expert

Licensed User

Longtime User

• Mar 25, 2011

• #4

gorelshv said:

I would like to know how b4a handles such cases.

Click to expand...

B4A doesn't handle it, the database code does. You will have to look up details of the database implementation if you want such information.

 

Upvote 0

G

gorelshv

Member

Licensed User

Longtime User

• Mar 25, 2011

• #5

I've spent time reading on sql and one thing I've noticed is that issueing two write commands simultaneously can lead to a deadlock as each transaftion waits for the other to complete. Could such a thing happen in a b4a app? Also, I didn't quite understand what is indexing and how does it solve the problem.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 27, 2011

• #6

Basic4android uses Android implementation of SQLite. According to their documentation it should be thread safe. Which means that it shouldn't dead lock (assuming that your code doesn't dead locks).

Indexing is not related to this issue. By creating an index for a column, you can access specific items much faster.

 

Upvote 0

G

gorelshv

Member

Licensed User

Longtime User

• Mar 27, 2011

• #7

It's clearer now, thanks.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 15, 2014

• #8

This thread is very old. Please start a new one.

 

Upvote 0