Many highlights in attachments: a risk?
Hi, I'm dealing with a middle-sized Zotero database (3k items, 1k of PDFs attached, the Sqlite db is 170 MB) but growing very fast, and I'm trying to decide if highlight the PDFs with the Zotero PDF reader or use an external tool. For academic work, I have to highlight many sentences in each PDF, and I'm afraid to fill the itemAnnotations table of the Sqlite database of Zotero with so many records to slow down Zotero or compromise its reliability.
So my question is: if the itemAnnotations table had - let's say - 300k records each of them containing a sentences of about 200 characters, will Zotero be still responsive? Furthermore, if the Sqlite database size were to grow up to 10-20 GB, will Zotero will be still reasonably fast and reliable on a modern Mac?
Thanks for help.
So my question is: if the itemAnnotations table had - let's say - 300k records each of them containing a sentences of about 200 characters, will Zotero be still responsive? Furthermore, if the Sqlite database size were to grow up to 10-20 GB, will Zotero will be still reasonably fast and reliable on a modern Mac?
Thanks for help.
-
dstillmanThe annotation tools are obviously meant to be used. If you encounter a performance problem, you should report it, but we're not going to have a speculative discussion with you about a particular database table.