-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 06/26/2010 09:48 PM, Bill Webster wrote:
> Closing file handles and statement handles is not particularly drastic. Not
> to be encouraged obviously, but no worse than sudden termination of the
> program or power-off.

What is it exactly that leads you to want to do this abort, not keep track
of what you are using, yet not want to terminate the process?

Something I see some developers do is code as though all SQLite objects are
precious and go to great lengths to keep them around and reuse them.  This
leads to complicated code.  Call close/finalize or equivalent functions the
moment you are done with the item.  Make new items every time (eg statements
and even connections).  You can do profiling later to see if being
profligate even shows up in the traces before going ahead and "optimising"
by keeping them around long and making the code far more complicated and
prone to errors.

- From your mail headers it would seem you are a Windows user.  Traditionally
Windows developers have considered creating more than one process, or having
one process per area of work done to be too expensive, especially as Windows
process creation is expensive.  This leads to there being a single
monolithic program will all the functionality built in, lots of threads etc.

You don't have to structure things that way.  Using lots of single
functionality processes is fine, and a heck of a lot easier to test,
develop, distribute etc.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkwm2uAACgkQmOOfHg372QTOkwCgqXjVgPFdMUX+8ZLE5hc8yI3N
MtsAnR0Mczu5KCcL1nCC8Cw1VvPJjk6d
=Mgce
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to