04-27-2012 05:48 PM
i am doing a chat app and i have a problem with the performance when i store data in my sqlite db but i read that i can manage this with a daemon process or thread i don't sure if there are a difference or if the same, well someone can give me a guide about how manage background process when i can store in sqlite and how access data of this process with my gui app
04-30-2012 07:53 AM
I guess the first question should be to find out why you are using SQL to save this data? I would have thought that persistent store would have been easier to use and is much faster.
04-30-2012 09:14 AM
We have used a lot of SQLIte in our applications and I have always followed this guide..
This may help you as well.
05-02-2012 04:41 PM
my problem start when i recieved a new message in my chat app so i save this message and show this but what happen when i recieved 10 messages in the same time this is the problem because i have 10 current inserts in my db in same time , so do you have any idea about how handle this inserts
05-02-2012 06:03 PM
don't lose you time with database. It hangs app and device on some old oses (you could simply comment db calls and see that app and device works without issues) even if it started in separate thread.
You could use some file based databases or just save data in clever way in persistent store.
What is the name of app?
05-03-2012 05:35 AM
I agree with Eugen, from a performance and functionality perspective, you can use other things to SQL.
If you really must use SQL, then I think that you would be able to use the database, but you should create a single database update Thread, and supply the updates to that Thread.