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
intended
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 ar
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 "smallish"
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 ex
4 matches
Mail list logo