Problem solved. I updated the version on the server and it completes in 16 seconds.
To answer your question, I am using the find command to created a delimited text file. I copy that file to my home PC then importing that file into a sqlite database table. I use the same process to create a text file on my home PC then import that as well. The tables are very simple. Just filename, type, date, time and epoch seconds (easy comparison). On Mon, Jul 27, 2015 at 10:16 AM, Tim Streater <tim at clothears.org.uk> wrote: > On 27 Jul 2015 at 13:44, rotaiv <rotaiv at gmail.com> wrote: > > > Where is the resource bottleneck that causes a simple query to never > > complete after 40 minutes > > > > I am using sqlite to synchronize files on my home PC and my work PC. I > > created a file listing of each computer and imported into separate > tables. > > And how are you doing this? > > > Then I used the following query to locate missing files. The ?ftype? is > > simply ?F? for file or ?D? for directory. > > Have you written a program to do this or are you using the sqlite3 shell > program? You're presumably working with one database that you move between > machines so that you can import the listings created on each machine. Is > this correct? What is the schema for your database? > > -- > Cheers -- Tim > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > >
