Submitted by Cyganet on 2021/04/30 03:52

Hi!

I am trying to keep the size of my database (.SNDB file) down to reduce the sync time to OneDrive. I have a large collection of web clips and emails sent to IQ (via EmailToIQ and the web clipper). I want to store all of those as external HTML files instead of inside the database.  Is it possible to add an option - either for the database or for a grid - to use external HTML files by default?  Right now I am manually converting them to external files.

Edit: another thought - it could be an option in the web clipping window - save to external HTML file.

 

Thank you!

Comments

Hi Cyganet,

  1. Can you report the IQBase size ? (perhaps compact it)
  2. If the IQBase directly on OneDrive ? Better to use the sync config detailed here 
  3. How about using Dropbox ? It only syncs changes

Pierre

Hi Pierre,

I have already compacted the database. It is currently 51MB after roughly one year of use and I expect it to grow by at least that each year.  Yes, it is directly on OneDrive, which is where I store all my working data.  I don't use dropbox, and I don't keep any local-only data on my hard drive.

I don't understand what the sync folder does. Perhaps it's intended for the situation when the main database is local only. I still have the entire database stored in OneDrive, so does splitting it into a main folder and sync folder change what needs to be uploaded when I edit the database?

Does using the sync folder introduce an extra sync step when I open IQ on another machine? I'd rather not have to click through an extra "yes please update this" every time I open a database.  I open and close databases a lot (several times a day on the same machine).

Regardless of sync method, I want to keep the database size down, so being able to automatically save to external HTML files would be nice to have, if it is possible.

Thank you.

 

IQ is using a database engine, so any change you make is immediately saved. OneDrive then sees the change and uploads the file... 10 small changes, 10 uploads. Plus I don't think OneDrive syncs just the changes, but rather sends the whole file each time (must check this)

The idea of using the sync method I referenced, is that you control the frequency of the sync, hence much improved performance. In addition, Dropbox just sends the changes, so uploads are small

Also, if you open the computer and IQBase before OneDrive it's thing, you could get a sync conflict and/or have corrupted/bad data...

Lastly, 50 MB/yr isn't much

But the idea of greater use of external files is worth considering...

Suggestions