Chia sync DB files

Encounter a problem related to the pool or have a request for a feature? Post your issue here and we will help you out.
Forum rules
Welcome to the System Support forum! Encounter a problem related to the pool? Post your issue here and we will help you out.

Keep in mind that the forums are monitored by PROHASHING less closely than the official support channels, so if you have a pressing issue, please submit an official support ticket so that our Support Analyst can look into your issue in a timely manner.

We cannot answer financial questions related to your account on a public forum, so those questions should always be submitted through the orange Support button on prohashing.com/about.

For the full list of PROHASHING forums rules, please visit https://prohashing.com/help/prohashing- ... rms-forums.
Locked
User avatar
Mastermind007
Posts: 109
Joined: Wed Aug 25, 2021 2:02 pm

Chia sync DB files

Post by Mastermind007 » Sat Oct 09, 2021 9:20 am

Has Prohashing thought of providing a nightly build of the Chia sync db files?
Per my understanding they are sqlite files, which should work well for this.
As if stands now it will take a day for the initial sync to finish.

Perhaps have it as a Trusted Miner perk to prevent those not actually mining with Prohashing from taking up bandwidth.

Just a thought.
User avatar
BMChris
Posts: 60
Joined: Fri May 14, 2021 8:10 pm

Re: Chia sync DB files

Post by BMChris » Sat Oct 09, 2021 11:38 am

I like this idea. What kind of size are they?
User avatar
Mastermind007
Posts: 109
Joined: Wed Aug 25, 2021 2:02 pm

Re: Chia sync DB files

Post by Mastermind007 » Sat Oct 09, 2021 12:47 pm

Should be around 11.5GB.

Total blocks in chain: 973,389
What I have sync'ed so far: 89,152
Current size of my DB files 1.07 GB
I am about 9% sync'ed

I am basically experimenting. I have 12TB of storage for plots. No money invested as this was components I had on a shelf.
To do it right the drives would be $150 to $200 per 1TB. This is for PCIe NVMe heavy usage drives. The ones I have are not super high-end versions so they would have a short lifespan if running long term.
jkndt
Posts: 16
Joined: Sat Nov 17, 2018 6:50 am

Re: Chia sync DB files

Post by jkndt » Sun Oct 10, 2021 7:13 am

Although this sounds like a good idea, this wouldn't really help anyone.
The database is file shared amongst all the peers that your system connects to, like a torrent, and is freely hosted because of it. If prohashing were to host this, it would cost them in bandwidth.
You may be able to edit the config.yaml file to increase the number of connected hosts/peers so that you can sync the db more quickly, then once fully synced, return it to it's default. YMMV.
User avatar
Mastermind007
Posts: 109
Joined: Wed Aug 25, 2021 2:02 pm

Re: Chia sync DB files

Post by Mastermind007 » Sun Oct 10, 2021 8:39 am

I was referring to download the database file just for initial setup of the Chia app, If you have a copy of the db files from the day before then you would only need to sync the last 24 hours from the network.

Ex: Yesterday, if I could have downloaded the DB files the sync to the network would have taken little time compared to the 24 hours to sync from zero.
Locked