2

I'm facing problem in gsoap , if two user go to register at a same time then database is
locked, i think its threading problem , how to handle it, please insist me. I am running multiple threads in background. every 5 seconds sending data to server.

Improve this question
1
  • write a thread safe code and check your Sqlite features - sqlite.org/threadsafe.html Commented Jul 14, 2012 at 9:53

1 Answer 1

Reset to default
1

Generally speaking, when working with a database it should be set up so you don't have to worry about things like that. As EIYusubov suggested, you need to look into the code you are using for for DB access. What types of reads and writes are you requesting?

(Most) DBs are intended to be multi-user and multi-threaded / multi-session. Sending data every five seconds (as suggested by Tech.Rahul) is or should be nothing to a DB server, and you shouldn't have any lock contention.

It's possible you could have a case where one user is getting stale data.

User A @ 4.9 seconds - retrieves dataset XYZ^1 
User B @ 5.0 seconds - updates dataset XYZ^1 to become => XYZ^2
User C @ 5.1 seconds - retrieves dataset XYZ^2

Note: times in the example are just arbitrary

So User C wouldn't have what User A is looking at, but that' not going to cause a deadlock situation as you described. Given the short amount of time elapsed between User A and User C, then User A could be said to be looking at dirty data.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.