# Store and Forward - Disk Cache slow **URL:** \ **Category:** Ignition\ **Created:** [March 4, 2020, 6:52pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811 "2020-03-04T18:52:03Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![michael.cramer](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@michael.cramer](https://forum.inductiveautomation.com/u/michael.cramer)\ **Post date:** [March 4, 2020, 6:52pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811/1 "2020-03-04T18:52:04Z")
Using 8.0.8. Our Store and Forward disk cache is extremely slow. If we disable the disk cache, we can enter records from our tags into our MSSQL 2016 enterprise database at a minimum rate of 5000 transactions/sec. Transactions / sec are usually in the 1000-2000 range. When we enable our ignition local disk cache, the store and forward disk cache transactions go quickly as well, but only as long as the disk cache is virtually empty. Turning on the ‘force use of disk cache’ option will eventually cause too many records to build up in the cache, and our forwarding rate will slow to 0-400 transactions / sec. This causes more records to build up, and eventually the rate of insertion slows to zero. The work-around is to disable the store and forward disk cache, and we have a new database connection set up with one of these old caches, slowly draining into the database at a rate of about 30 transactions / sec. This causes deadlock quarantines, but those can be retried, so at least we can get our data _eventually_. I have a ticket in with support, but it is not moving and we’re stuck with a problem where if our sql server is rebooted, we’re going to end up losing transactions. The memory buffer is only big enough to store about 20 seconds of data, and support recommended that we decrease the size of this buffer (not sure why). This isn’t long enough for our SQL server to reboot fully, especially if the server requires updates (Windows). Anybody run into this issue, where your server and database can handle the load but the local store & forward disk cache isn’t able to forward the transactions fast enough to keep up? ---
**Author:** ![m.sanders](https://avatars.discourse-cdn.com/v4/letter/m/df705f/32.png) [@m.sanders](https://forum.inductiveautomation.com/u/m.sanders)\ **Post date:** [March 6, 2020, 8:05pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811/2 "2020-03-06T20:05:29Z")
I had something similar happen and was able to resolve it by increasing the number of connections I had with the history database. When the store and forward starts filling up Ignition will use all of the DB connections to push to the DB. If those connections are also getting used by Ignition to render charts and such there might just not be enough connections to push all of the data through. Another thread that might help: [Store and Forward Thruput](http://forum.inductiveautomation.com/t/store-and-forward-thruput/16630) ---
**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Post date:** [March 6, 2020, 8:45pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811/3 "2020-03-06T20:45:44Z")
I had this problem as well. Turns out when upgrading the jdbc driver is not updated to a Java 11 compatible version, that has to be updated manually. This is my post, may solve your problem. > [@Store and Forward Stops Forwarding To Database](http://forum.inductiveautomation.com/t/store-and-forward-stops-forwarding-to-database/32521): > > Ever since I have updated to Ignition 8.0.8 the store and forward engine will randomly stop forwarding to the database and will just fill up the disc storage. Restarting the server, restarting the SQL Bridge module and disabling and enabling store and forward doesn’t ever kick it into forwarding the records to the database. I always have to stop the store and forward engine and delete the files and then reenable it. This is the third time in a week that this has happened now. Is there a way to f… ---
**Author:** ![benjamin.samson](https://avatars.discourse-cdn.com/v4/letter/b/7cd45c/32.png) [@benjamin.samson](https://forum.inductiveautomation.com/u/benjamin.samson)\ **Post date:** [July 14, 2020, 10:57pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811/4 "2020-07-14T22:57:14Z")
I am having the same issue with MS SQL Server 2017 and Ignition 8.0.13. If I enable the disk cache, it sometimes fills really quickly and it’s very hard to drain it because it is so slow. I ended up deactivating the disk cache as well. I updated the JDBC driver to the latest one (mssql-jdbc-8.2.2.jre11.jar) but it did not seem to make a difference. Did you solve this issue? ---
**Author:** ![jeremy.browning](https://avatars.discourse-cdn.com/v4/letter/j/5e9695/32.png) [@jeremy.browning](https://forum.inductiveautomation.com/u/jeremy.browning)\ **Post date:** [December 15, 2020, 9:54pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-disk-cache-slow/32811/5 "2020-12-15T21:54:30Z")
I have a customer that is experiencing this same issue as well. They are using MS SQL Server 2016 and just recently upgraded to Ignition 8.1.0. The disk cache fills up over a period of a couple hours and cannot forward records fast enough to keep up. While using the cache, it receives data at around 75 transactions/sec and forwarding to the database around 65 transactions/sec. I even deleted the old data cache and created a new one, with no observable improvement to performance. I’m not sure why the system is now doing this as it had no issues while using Ignition 7.9.12. The temporary fix was to disable the cache to allow the tag historian to save to the database. Updating to the latest driver (mssql-jdbc-8.4.1.jre11) had no effect. Has anyone been able to resolve this issue?