[sqlite] Query hung. Any help. (sqlite & dbi)

Nice Explanation Igor. As it turns out, virtually all of the rows will match up as you correctly suspected. Thanks again. Jack The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the

[sqlite] Query hung. Any help. (sqlite & dbi)

Thanks Igor, works great! Btw, was there something incorrect about the way I had the query setup? Thanks, Jack The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you

[sqlite] Query hung. Any help. (sqlite & dbi)

Query hung. Any help. (sqlite & dbi) SQLite version 3.7.2 built on This is perl, v5.8.8 built for x86_64-linux-thread-multi DBI 1.611 DBD::SQLite 1.29 Centos Linux(2.6.18-164.11.1.el5xen) 64bit. Below are output snippets from two dbi trace files. In the first snippet, the sqlite.db is

[sqlite] Potential Bug, Select appears to hang

There are more fields in each table, but for the sake of brevity, I ommited them from the snippets below. With smaller data sets, the second query works just fine as well. SELECT COUNT(*) FROM link; 960219 SELECT COUNT(*) FROM node; 812193 Pvid's are INTEGERS. On linux, the following query