On Fri, Jun 22, 2012 at 10:39 AM, Jeff Archer <[email protected]> wrote:
> I have seen something that seems strange and wonder if anyone has any > thoughts? > > I have been using SQLite for a long time now and never seen anything > similar. Had been using 3.7.6.1 and have now upgraded to 3.7.13 but > behavior has not changed. > > In a Debug build this code works as expected but in Release build I am > having only 2 of the 7 rows be inserted. I have found a workaround in that > if I Sleep() for 100ms after each INSERT the Release build then works as > expected. > Are you checking the return codes from your INSERT statements? Have you enabled error logging using sqlite3_config(SQLITE_CONFIG_LOG, ...)<http://www.sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglog>? Are you getting any error message back from that? > > Unfortunately a lot of code involved so it will take a while to pare down > to small test case and since I have a workaround I will hope for a general > answer first. > > Inside a BEGIN IMMEDIATE, I do a SELECT from table Objectives and get back > 7 rows which are held in a list. Iterate that list and for each do a > SAVEPOINT then INSERT a row into table Calibration then do RELEASE. When > finished iterating the list do COMMIT. > > Windows 7 64bit. Visual Studio 2010. Real HDD not SSD. The file is on > local machine but is opened using a network path. i.e. > \\MACHINENAME\Data\Calibration.db > Thank you in advance for your time on this matter. > > Jeff Archer > Nanotronics Imaging > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
