Processing Ajax...

Title
Close Dialog

Message

Confirm
Close Dialog

Confirm
Close Dialog

extending ssd life for clipboard fusion database

User Image
SEZER
18 discussion posts
What kind of settings should be made in clipboard fusion in order to increase the writing life for those who use ssd, it writes 30 gb of data on each on and off clipboard fusion although the clipboardfusion.db file is 3.21 gb
• Attachment [protected]: Ekran goruntusu 2022-06-16 214036.png [259,726 bytes]
Jun 16, 2022  • #1
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Could you send me a copy of your troubleshooting info? Here are the steps:
  • Open the Settings > Troubleshooting tab
  • Click the "Export Info to File" button
  • Reply with the file attached

Thanks!
Jun 17, 2022  • #2
User Image
SEZER
18 discussion posts
Quote:
Could you send me a copy of your troubleshooting info? Here are the steps:
  • Open the Settings > Troubleshooting tab
  • Click the "Export Info to File" button
  • Reply with the file attached

Thanks!
• Attachment [protected]: ClipboardFusionDebugInfo.zip [11,554 bytes]
Jun 18, 2022  • #3
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Thanks for sending that over. If you don't need the clipboard history, can you try clearing it and then restart ClipboardFusion, and check the size of the database? If it's smaller, can you restart a second time and check how much disk activity is happening?

Thanks!
Jun 20, 2022  • #4
User Image
SEZER
18 discussion posts
Quote:
Thanks for sending that over. If you don't need the clipboard history, can you try clearing it and then restart ClipboardFusion, and check the size of the database? If it's smaller, can you restart a second time and check how much disk activity is happening?

Thanks!


I cut the 3.21 gb size file, I create a 0 size database for backup purposes, but why is it writing on the disk 8-9-10 times, what settings can I make to make clipboard fusion smaller
Jun 20, 2022  • #5
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
We took a look into this and we have an idea on where those writes are coming from, so we've added it to our list to look into. We'll let you know if we have any news on this going forward.

Thanks!
Jun 20, 2022  • #6
User Image
SEZER
18 discussion posts
C:\Users\SEZER\AppData\Local\Temp
ethylqs_Des4z9mA76Qeljf created temporary files, these are automatically deleted when clipboard fusion is loaded 14.07 gb here has disk writing

clipboardfusion.db-journal file is deleted after writing 3.61 gb disk

The clipboardfusion.db database file is writing 3.25 gb disk but the file is not deleted because the database file

It is writing 21 gb disk, ssd lifetime protection settings for 3.25 gb database file will come out quickly, I'm waiting
Jun 21, 2022  • #7
User Image
SEZER
18 discussion posts
is there any progress?
Jun 24, 2022  • #8
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Nothing yet, we'll let you know when we have any news :)

Thanks!
Jun 27, 2022  • #9
User Image
SEZER
18 discussion posts
Quote:
Nothing yet, we'll let you know when we have any news :)

Thanks!

The ssd is dying, dear programmer, is there a tiny little change? Good luck with ::)
Jul 12, 2022  • #10
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
It looks like we should have this fixed up for our next beta, so we'll let you know once it's released.

Thanks!
Jul 19, 2022  • #11
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
We've released a new beta with some added changes. Can you try updating and let me know if the issue persists?

Thanks!
Jul 26, 2022  • #12
User Image
SEZER
18 discussion posts
Quote:
We've released a new beta with some added changes. Can you try updating and let me know if the issue persists?
Thanks!

I downloaded it now I installed it I will tell you how much of a change it is in size in gigabytes
Isn't that the change?
Fix: Copying image files from File Explorer no longer causes the history database to grow by large amounts
may be true, hope it works
• Attachment [protected]: Ekran goruntusu 2022-07-26 194928.png [994,846 bytes]
Jul 26, 2022 (modified Jul 26, 2022)  • #13
User Image
SEZER
18 discussion posts
data write size to database ssd 33gb no improvement
Jul 27, 2022  • #14
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Was that from the first time you launched ClipboardFusion after updating? Does it continue to climb if you restart ClipboardFusion?

Thanks!
Jul 27, 2022  • #15
User Image
SEZER
18 discussion posts
Quote:
Was that from the first time you launched ClipboardFusion after updating? Does it continue to climb if you restart ClipboardFusion?

Thanks!


It reaches the same amount of data writes in both ways
Jul 27, 2022  • #16
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Strange, I've been testing with that same program on my end but it doesn't seem to read any data being written with Beta 4 on launch. I've been testing with the following steps:

1) Open SsdReady and clear the collected data via Menu > Clear Collected Data
2) Exit ClipboardFusion
3) Start SsdReady
4) Open ClipboardFusion
5) Check the Processes tab in SsdReady

Are you testing the same way?

Thanks!
Jul 27, 2022  • #17
User Image
SEZER
18 discussion posts
Quote:
Strange, I've been testing with that same program on my end but it doesn't seem to read any data being written with Beta 4 on launch. I've been testing with the following steps:

1) Open SsdReady and clear the collected data via Menu > Clear Collected Data
2) Exit ClipboardFusion
3) Start SsdReady
4) Open ClipboardFusion
5) Check the Processes tab in SsdReady

Are you testing the same way?

Thanks!


STEP 1-2-3-4-5 RESULT
folder way: C:\Users\SEZER\AppData\Local\Temp
file name: etilqs_q0Kbh49ILZRfMj3 3.46 GB
file name: etilqs_z15K8jTy0BmoVlA 6.55 GB
file name: etilqs_vzFzNjhPDIjawD8 3.48 GB
file name: etilqs_CV1QKVTF0bmjItt 6.54 GB
TOTAL SİZE 20.03 GB
• Attachment [protected]: Ekran goruntusu 2022-07-27 233902.png [267,526 bytes]
Jul 27, 2022  • #18
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
If you don't need your history, can you clear it and then run the vacuum (ClipboardFusion Settings > Clipboard History > Vacuum), and confirm that the database file size is smaller after doing that?

Can you also set the Database Cache Mode in the Advanced Settings to 2, and then follow those steps again and see if the issue persists?

Thanks!
Jul 28, 2022  • #19
User Image
SEZER
18 discussion posts
Quote:
If you don't need your history, can you clear it and then run the vacuum (ClipboardFusion Settings > Clipboard History > Vacuum), and confirm that the database file size is smaller after doing that?

Can you also set the Database Cache Mode in the Advanced Settings to 2, and then follow those steps again and see if the issue persists?

Thanks!

If I upload the database here, wouldn't it be easier if you could solve the problem?
Jul 28, 2022  • #20
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Yep, if you're comfortable sending over your database we can test it out :)

Thanks!
Jul 28, 2022  • #21
User Image
SEZER
18 discussion posts
Quote:
Yep, if you're comfortable sending over your database we can test it out :)
Thanks!

https://filedn.eu/lJzVSbKgtXzHjsfCven0RDp/clipboardfusion.db
you can send compressed version there was data from june 2020 now starting october 2020 data
Jul 28, 2022 (modified Jul 28, 2022)  • #22
User Image
SEZER
18 discussion posts
Quote:
Yep, if you're comfortable sending over your database we can test it out :)

Thanks!

Sir, I am waiting for the developments.
Jul 29, 2022  • #23
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
Thanks for sending that over. This is likely due to the size of the database already being so high. If you clear it out and run the vacuum, and then adjust that advanced setting, new copies should be quite a bit lower.

Thanks!
Jul 29, 2022  • #24
User Image
SEZER
18 discussion posts
Quote:
Thanks for sending that over. This is likely due to the size of the database already being so high. If you clear it out and run the vacuum, and then adjust that advanced setting, new copies should be quite a bit lower.

Thanks!

4 gb database logically does not need to write to 4 gb ssd, is it an abnormal change to write more data at the maximum?
Jul 29, 2022  • #25
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
The SQLite library is loading the database into a cache on disk when ClipboardFusion starts up and reads the rows because the database is so big. If you want to keep the existing history database but reduce the disk writes, you can set the Database Cache Mode advanced setting to 2 and restart ClipboardFusion. That will tell SQLite to cache it in memory instead of on disk. Please note that you'll need to make sure you have more than 4 GB of free memory available to do this.

Clearing the history and doing a vacuum will reduce the database size to around 2 MB, and any new files you copy will not cause the database to grow so big as we have fixed that issue in the beta as well.
Jul 29, 2022  • #26
User Image
SEZER
18 discussion posts
Quote:
The SQLite library is loading the database into a cache on disk when ClipboardFusion starts up and reads the rows because the database is so big. If you want to keep the existing history database but reduce the disk writes, you can set the Database Cache Mode advanced setting to 2 and restart ClipboardFusion. That will tell SQLite to cache it in memory instead of on disk. Please note that you'll need to make sure you have more than 4 GB of free memory available to do this.

Clearing the history and doing a vacuum will reduce the database size to around 2 MB, and any new files you copy will not cause the database to grow so big as we have fixed that issue in the beta as well.


Database Cache Mode 2 is done
Is there a way to easily delete images in the database or large rows?
Can I merge the 2 databases or can you do it?
Jul 29, 2022  • #27
User Image
SEZER
18 discussion posts
Quote:
The SQLite library is loading the database into a cache on disk when ClipboardFusion starts up and reads the rows because the database is so big. If you want to keep the existing history database but reduce the disk writes, you can set the Database Cache Mode advanced setting to 2 and restart ClipboardFusion. That will tell SQLite to cache it in memory instead of on disk. Please note that you'll need to make sure you have more than 4 GB of free memory available to do this.

Clearing the history and doing a vacuum will reduce the database size to around 2 MB, and any new files you copy will not cause the database to grow so big as we have fixed that issue in the beta as well.


If there is a boss database editor, let me quickly delete pictures and things that take up large size with multiple selection. It is very difficult to remove one by one and it is a waste of time if you have a program, it would be nice if you could send an editor.
Aug 4, 2022  • #28
User Image
Anthony Kirkland
6 discussion posts
Quote:


If there is a boss database editor, let me quickly delete pictures and things that take up large size with multiple selection. It is very difficult to remove one by one and it is a waste of time if you have a program, it would be nice if you could send an editor.


you might have a look at https://sqlitestudio.pl/. I have used it in similar situations to the one you describe.
Aug 6, 2022  • #29
User Image
SEZER
18 discussion posts
What is the password to open the database encrypted?
Aug 7, 2022  • #30
User Image
Anthony Kirkland
6 discussion posts
Quote:
What is the password to open the database encrypted?


CAn't help you with that, sorry. That's a support question.

The other examples I referred to was a similiar case but not with Clipboard Fussion.

The Devs may share that password, then they may not.
Aug 9, 2022  • #31
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
I've attached a script below that will remove all images from the history. Please note this is not reversible, so you may want to make a backup of your database first.

Your database is encrypted for added protection, but we can't hand out that password.
• Attachment: Remove All Images from Clipboard History.cfmacro [12,792 bytes]
Aug 9, 2022  • #32
User Image
SEZER
18 discussion posts
Quote:
I've attached a script below that will remove all images from the history. Please note this is not reversible, so you may want to make a backup of your database first.

Your database is encrypted for added protection, but we can't hand out that password.


I ran the macro you prepared, it doesn't show in the clipboard history, but it doesn't delete it from the database in terms of size, the database size has not changed 4.08 GB database size
Aug 10, 2022  • #33
Owen Muhlethaler (BFS)'s profile on WallpaperFusion.com
You'll need to run the vacuum found in the ClipboardFusion Settings > Clipboard History tab to reclaim the space after deleting those entries.
Aug 10, 2022  • #34
User Image
Ben_
151 discussion posts
Quote:
You'll need to run the vacuum found in the ClipboardFusion Settings > Clipboard History tab to reclaim the space after deleting those entries.


What is this "Vacuum" ? I guess I never see it becuase I always run Clear Clipboard Contents and History often. I wish there were a single option to clear it all.
Sep 30, 2022 (modified Sep 30, 2022)  • #35
Keith Lammers (BFS)'s profile on WallpaperFusion.com
It's just a way to manually clean up deleted space in the history DB. When you say you want an easy way to clear everything, do you mean current clipboard contents and clipboard history at the same time? Or are you wanting to clear the other pinned and online lists as well?
Oct 3, 2022  • #36
Was this helpful?  Login to Vote(1)  Login to Vote(-)