Hello Dan
>Do the tasks share a heap? And do you have multiple connections >to the database (multiple calls to sqlite3_open() or sqlite3_open_v2(). I would like to keep the implementation as general purpose as possible so we can use sqlite in the future in differient Applications. Therefore I will say I need to have multiple connections to the database. Each of the tasks in the Application, have their own task stack, but mallocs() for example will all take blocks from a common memory pool. Not too sure of how this effects my locking strategy implementation. To be honest, despite having read the locking bits of osUnix.c numerous times, I am still pretty much lost. Regards Geoff Dan Kennedy-4 wrote: > > > On Mar 16, 2010, at 5:22 AM, GeoffW wrote: > >> >> Hello Dan >> >> Thanks for your useful input. To answer your questions. >> >>> Do you have any file-locking primitives provided by the OS? >> There are no file locking OS Primitives at all that I can use. >> >>> Do you have clients connecting to the database from multiple >>> processes? Or only multiple threads within the same process? >> >> My Application doesnt have a concept of processes and threads as you >> might >> find in Windows. >> Think of it as a small data collection embedded Application. The >> platform >> has essentially 1 fixed Application running, made up of say 10 >> different >> concurrent tasks. > > Do the tasks share a heap? And do you have multiple connections > to the database (multiple calls to sqlite3_open() or sqlite3_open_v2(). > > If you only have one connection, then you don't need any locking. Have > xCheckReservedLock() set its result variable to 0 for all calls. > > If all tasks share a heap, maybe you can implement locking in-memory > using global variables in the VFS layer. Or, if you strictly use > shared-cache mode, you will not need any locking. > > Dan. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Porting-Sqlite-to-MQX-OS%3A-Question-2-tp27874124p27918689.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users