Using pysqlite2 I noticed (using ps) that whenever I connected to a database for the first time an extra thread is spawned. At first I thought this might be the doing of pysqlite but a quick test with the sqlite3 command line tool confirmed that this occurs within sqlite3 itself:
$ sqlite3 gen-us_en.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> [1]+ Stopped sqlite3 gen-us_en.db $ ps PID TTY TIME CMD 5484 pts/16 00:00:00 bash 5753 pts/16 00:00:00 sqlite3 5754 pts/16 00:00:00 sqlite3 5757 pts/16 00:00:00 ps $ cat /proc/version Linux version 2.6.11-gentoo-r4 (gcc version 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)) #6 SMP Mon Apr 4 10:20:09 EST 2005 A look at the sqlite3 source shows that pthread_create is only called twice and is immediately followed by a matching pthread_join - where does the extra thread come from? Regards, Iker -- Iker Arizmendi e: [EMAIL PROTECTED] w: ikerariz.blogspot.com