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
