8.3 Beta 2. Awful indexing performance on my computer

George
George Member Posts: 479 ✭✭

I added the free book from Faithlife and the indexing for the book took over 40 minutes.  It is true that my computer is not a top of the line computer with a fast SSD drive.  It is an older 8 core AMD 3.5 GHz CPU, 8 GB of RAM and a 2TB 7200 rpm hardrive. Still, over 40 minutes is pretty bad.

1351.LogosIndexer.zip

Comments

  • Dave Hooton
    Dave Hooton MVP Posts: 36,126

    Indexing took 45 min overall. Indexing for the book took 3 min. Merging the index work for that book with the rest of the index took 34 min, and the many SQLite warnings indicate that performance is slower than anticipated. The other important part,  Building the term/document info index took  6 min 36s.

    The merge and the term/document info index (40 min combined) will take roughly the same time, no matter how many books are indexed. I think the badness is a reflection of your old CPU. You can check the consistency by re-indexing another resource. In the GO Box, type reindex ESV (or a similar resource). It should take longer, but only by a few minutes. Upload the log.

    Dave
    ===

    Windows 11 & Android 13

  • Mark Barnes
    Mark Barnes Member Posts: 15,432 ✭✭✭

    I think the badness is a reflection of your old CPU

    You're right that normally far more time is taken merging than indexing, and therefore it doesn't make a huge time difference whether you're adding 1 book or 20.

    The biggest factor in the merge is the size of your library. Big libraries take longer. Nothing can be done about that. But I don't agree with you about CPU. The next biggest factor in this case will be drive speed. I have an old 8-core CPU, but a fairly fast SSD, and adding a resource to my index only takes about 15 minutes — even with a very large library.

    This is my personal Faithlife account. On 1 March 2022, I started working for Faithlife, and have a new 'official' user account. Posts on this account shouldn't be taken as official Faithlife views!

  • Dave Hooton
    Dave Hooton MVP Posts: 36,126

    But I don't agree with you about CPU.

    Yes, I should also have mentioned the HDD (even though 7200RPM is better than the usual 5400 RPM).

    Dave
    ===

    Windows 11 & Android 13

  • Bradley Grainger (Logos)
    Bradley Grainger (Logos) Administrator, Logos Employee Posts: 12,086

    Adding a SSD to your system is probably the most significant upgrade you can make to improve the performance of Logos.

    Your computer: (1m 16.9s) Indexing LLS:9780830878291
    My computer: (453ms) Indexing LLS:9780830878291

    Your computer: (34m 4.6s) Merging postings...
    My computer: (11m 9.1s) Merging postings... [Note: I probably have a lot more resources than you do]

    Your computer: (45m 10.5s) Indexing.
    My computer: (18m 14.5s) Indexing. [You could probably expect to see 10 minutes (or less) with an SSD and a smaller library than I'm testing with]

  • George
    George Member Posts: 479 ✭✭

    Adding a SSD to your system is probably the most significant upgrade you can make to improve the performance of Logos.

    I've added a SSD just for Logos and, not surprisingly, indexing is faster.

  • Dave Hooton
    Dave Hooton MVP Posts: 36,126

    Dave
    ===

    Windows 11 & Android 13