Database Item Counts

I need an explanation of Database item counts in DTTG3. On the “home” screen next to each database a number is listed. For instance in one of my databases it is 4561. I open that database and hit “i” and it tells me the database has 4.4 GB (5346 items). What is the discrepancy here? The second set matches the data given in Database Properties for my Mac, so the item count on the home screen of DTTG is what doesn’t match.

Also, in the DTTG Help manual it says these numbers are the number of files in the Inbox, which is clearly not correct (I think that is a holdover from DTTG2, so should be corrected.)

Does this database contain any unread items? Then the number of unread items should be shown. Another difference is that the sidebar on the Mac and on the iPhone/iPad only shows the number of documents (excluding groups, smart groups, tags & feeds) whereas the database info/properties shows the total item count (including all items).

No unread items. On the Mac no total counts are shown at the database level, only if Unread items are present. I would find it useful if they were, but I only see item counts at the Group level. If item counts were present I could compare the counts on the Mac to the iPhone/iPad to double-check syncing is accurate.

And another question re. this:
I have noticed on my iOS devices that the document count in the sidebar matches across devices but the database info count does not – seems they should? Is this a problem?

The items counts will vary depending on what’s been read. If there are unread items, the number of unread items is displayed and the item count is emboldened. If there are no unread items, the item count is the total number of files in the location.

Does that help?

I understand that Unread item counts override the display of total item counts. That is not the issue and never was. In further discussion here let us assume there are no Unread items.

The questions I have now are:

  1. The counts under the Info tab (on iPhone/iPad) do not match on databases that are fully synced. Does that matter? Seems like they should match.
  2. DT3 on the Mac does not display total document count at the database level (though Christian implied it did). I know this used to be the case with DT2 (I think). I would like that if there was a way to enable it. (And yes, “Display number of items inside groups” in Prefs is turned ON.)

In DEVONthink To Go’s ? > Help > Appendix> Utility URL Commands, execute the fix command.
Do this on both iOS devices.
Does that resolve the counts?

I did “fix” on both iPhone and iPad and it did not resolve the counts.

Upfront: I don’t mean below comments as negative critique and might certainly be wrong or underestimate the complexity of the item count processes involved.

That said: IMO any maintenance url that is required to ‘fix’ something (that at least seems) as straightforward as a document count, comes across to me in essence as a sign that the underlying process is buggy.

I recently set up a new sync store, synced multiple devices with a newly installed DTTG3 (without DTTG2 being present) and ended up with one device that reported one document less in one database than all other devices including DT on macOS.

I then deleted DTTG3 on that device, installed it again, synced and all databases reported the same item count.

Considering the repeated questions about item counts on this discussion board, I would suggest a deeper dive into the working of that process and why people seem to keep reporting discrepancies (assuming no user error that is). But complex software like DT and DTTG will likely always have some process to take a deep dive into I think :grinning:

1 Like

I am having the same issue. After importing my Evernote to DT I have 13,834 items in my database on the desktop (found this by looking at “Database Properties…”) After sync with DTTG, if I go into that same database and click the “i” button it says 18,199 items. On the DTTG home screen it has the number 12,215 next to that database. (I executed the “fix” instructions twice. It changed the number that appears on the home screen to what it is now - before it was 8k something…)

Update: Checked again the next morning, and the numbers were much closer together: 13,834 vs. 13,782. Still not identical, but at least not apart by thousands of items. (The home screen number is still 12,215 though.)

The count between my Mac and iPhone and iPad is off again. Am comparing the All Documents and All PDF’s smart albums on the iOS and iPad OS devices. I then have similar smart groups on the Mac. The iPad and iPhone match each other but are different from the Mac. Up until this week all 3 were consistently matching. I have done full syncs. Maybe it doesn’t matter, but item counts is still confusing and makes one unsure that all your data is the same across devices. Every week or so I try to make sure everything is synced between all 3 and checking item counts is one of the only ways I can check. Is there anything I can do. The “Fix” command seems to have been removed from DTTG.

If I take the time to get the database property info on each database on Mac and iPhone, and compare them, they match. But item counts don’t. :man_shrugging:

Please try to long-press on the database in question on the databases screen, then choose Verify & Repair. We made this command more accessible :slightly_smiling_face:

I forgot to mention I had already done that. Did it again just now. Item counts between Mac and the iPad/iOS devices still not matching.

Off by what amount?

On the Mac it says I have 13277 documents in all my open databases, in DTTG on iPad/iPhone it says I have 13234 in the same set of databases. With PDF’s, on Mac 4654, on DTTG 4646. DTTG on the iPad and iPhone match, they don’t match the Mac. When I open the database properties on all devices in each database, they all match. Makes me think there is an issue with item counts.

With PDF’s, on Mac 4654, on DTTG 4646. DTTG on the iPad and iPhone match, they don’t match the Mac.

Are you referring to smart groups?

Just curious… Have you done a File > Verify & Repair on the databases in DEVONthink?

Yes to both questions.

Just installed the 3.5.7 update to DTTG, and the item counts match now. So, it appears the bug regarding smart groups they say they fixed was affecting this. :grinning:

3 Likes

Glad to hear it :slight_smile:

Yup. I synced before the update, counts were off. I updated and the counts immediately matched once again. So, definitely something in that update.