-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
rsts wrote:
> On my development computer, which is a moderately powered machine with
> plenty of disk and ram, I never have had a failure writing out and bringing
> back over 10,000 records at a time.
You can use virtualization software to make an instance with
considerably less memory and smaller disk.
> another run of the same data get "library used incorrectly" - seemingly
> random error messages that give me almost no information, except to let me
> know it failed.
Chances are you are ignoring an earlier error. SQLITE_MISUSE ("library
used incorrectly") really does mean that. Maybe a call failed due to
running out of memory and then you continued to use what you thought the
call succeeded on.
> I'm at a loss and would appreciate any constructive feedback as to how I
> might proceed.
Generally some sort of logging of all calls. You obviously already have
something along those lines to have diagnosed so far. On seeing every
single call, parameters and return it will become clear what the problem is.
It also doesn't hurt to run something like valgrind in case there is a
memory corruption problem.
> Is there a better way to 'export' the data from one database
> so it can later be brought back into that or a similarly structured
> database?
The SQLite shell has a .dump command that does the trick.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkkoug8ACgkQmOOfHg372QSmtACgg0pYS5HOgR0TZehKkOvLMHSp
TWsAn2ReefJUA3SbHrXBbz/P9Fsq6LNQ
=c5zP
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
