Windows build: createdb.js fails with ERRORLEVEL 3

[cmundi]

I built node-sqlite3 (in Release) for Windows using the work of TooTallNate here: #61 and verified that the small Ipsum Lorem example in the README.md worked as expected, using node 0.6.10.

Then I tried to node createdb.js. After the usual spike in memory use, I ended up with a big.db of zero bytes and "DOS" ERRORLEVEL equal to 3.

If I reduce the number of rows inserted by createdb.js from 10 million to 1 million, I get a database of size consistent with expectations (about 65MB) for the random strings.

Platform is 32-bit Windows XP.

My typical uses of sqlite are for small test databases, so I have no idea if this is an issue with SQLite on Windows (I know for a fact that this problem does not occur on 64-bit Linux where I have build and tested node-sqlite3 with node0.6.10.) or node or node-sqlite on Windows.

Please let me know how I can provide a more useful report.

[cmundi]

Forgot to mention... this box has 2GB of RAM and plenty of swap space

[cmundi]

I have verified the same behavior on a second 32-bit Windows XP box.

node .\test\support\createdb.js ==> abnormal termination, zero-size for big.db

The pagefile grows to about 2.4GB (from a quiescent state of ~500MB) and then node dies.

[cmundi]

I wonder if the problem has something to do with transaction buffering on on Windows. I probably will not have time to test this week...

[springmeyer]

we've reduced the size of the db now, so this should be avoided.