Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET Sqlite
Hello,
 
We can embade sqlite as beckend and it works fine with desktop application.
But what if we embade it for asp.net website? In web site multiple user will connect to the database concurrently.
 
Will it work fine with asp.net? Please explain.
Posted 9-Sep-11 21:38pm
Edited 9-Sep-11 21:47pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Multiple connections can be taken to SQLite. However, when modifications are made, only a single transaction can modify the data at any time. So if you're planning to have a high amount of concurrent modifications, I don't believe that SQLite will scale very well.
 
More info, see: http://www.sqlite.org/faq.html#q5[^]
  Permalink  
Comments
mmdullah at 10-Sep-11 2:53am
   
Thanks for your solution. I need not high amount of concurrent modifications, but I need concurrent modification. Number of my web user will be 20-50. but I need concurrent access of the database.
Mika Wendelius at 10-Sep-11 2:56am
   
SQLite locks the whole database for the time of the modification so it sounds like you should have a look at for example SQL Server Express Edition : http://www.microsoft.com/sqlserver/en/us/editions/express.aspx[^]
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

If you are using it for reading, then Sqlite is fine. If you want to have multi user writes, then I would STRONGLY suggest that it is a bad solution, and you should look at a either MsSQL or MySql - they are specifically designed for multiuser and should give you a lot less problems.
  Permalink  
Comments
mmdullah at 10-Sep-11 2:58am
   
Actually I need an embaded database. Thats why I need it. Also There will be small workload from the users but I need the concurrent access to the database
OriginalGriff at 10-Sep-11 3:55am
   
None of the embedded databases support concurrent updates well - they all lock the file for the update period. You really would be better off with a "proper" multiuser database.
mmdullah at 11-Sep-11 2:18am
   
Would you please suggest any multiuser embadable database?
OriginalGriff at 11-Sep-11 3:30am
   
As I said: "None of the embedded databases support concurrent updates well"
You need to move to a non-embedded database: the code is a lot more complex and only really works if you have a single application talking to the database, and a bunch of applications then talk to it. Look at MsSql (there is a free, Express version) or MySql. Most hosting providers provide one or the other if you are not handling the hosting yourself.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 DamithSL 265
1 CPallini 235
2 OriginalGriff 233
3 Maciej Los 195
4 George Jonsson 170
0 OriginalGriff 5,305
1 DamithSL 4,382
2 Maciej Los 3,760
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,901


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 10 Sep 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100