in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Sqlite on a unc path

Last post 01-06-2010 2:00 PM by pschomburg. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 01-06-2010 2:00 PM

    Sqlite on a unc path

    I used SQLite as my database in a point-of-sale program.  There are 3-4 computers.  1 stores, shares, and accesses the database.  The others acces the database through the shared folder.  I began to experience problems with slowdowns recently.  The read operations are quite frequent, sometimes several per second. The write operations are, at their peak, no more than 2-3 per second. So I started dividing the database into several "mini" databases, with some success.  My question is: Am I going in the right direction, should I assume my problem is elsewhere in the program, or am I misusing SQLite and need to change services?

Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems