On Sat, Sep 01, 2012 at 07:37:04PM -0700, J Decker scratched on the wall: > On Sat, Sep 1, 2012 at 7:32 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 2 Sep 2012, at 3:13am, shuif...@mail.ustc.edu.cn wrote:
> >> 2??how many user connections the sqlite can handler > > > > There is no limit in SQLite for connections. > > It is not advised to have multiple processes connect to same file. .. > but in-process probably no limit of connections. I'm not sure where this idea comes from, as it is perfectly acceptable to have multiple processes accessing the same database file. SQLite makes very little distinction between different connections from the same process and different connections from different processes, so there isn't any significant limit that applies to one situation that doesn't apply to the other. Concurrency is always an issue, and you don't want hundreds of connections banging on the same file, but that's true no matter if the connections come from the same process or not. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
