We've passed another milestone today by now storing over 50 million transactions that our users have entered. We're averaging about 28,000 new transactions added each day which is a huge amount!

We're extremely happy to see the site continually growing and we have some great updates planned for the future. We'll post more information about these updates over the next couple of months.

Thanks again for using ClearCheckbook!

There have been some announcements made in the news today about a new way that SSL connections could be exploited. They're calling this "Heartbleed" and more information can be found here http://heartbleed.com/.

We're running a version of OpenSSL that does not contain the vulnerability. This means that all of your data and information has been and will continue to be safe from SSL exploits while you're using ClearCheckbook.com.

The Windows Phone app has been discontinued.

The ClearCheckbook Money Management app for Windows Phone 8 has been approved and is now available to download! We're happy to bring ClearCheckbook to yet another mobile device which makes it easier than ever to stay connected to your finances.

If you're a Windows Phone 8 user, check out the store and search for the ClearCheckbook app. Try it out and let us know what you think by leaving us a comment and rating in the store.

The Windows Phone app has been discontinued.

We just submitted the ClearCheckbook Windows Phone 8 app to Microsoft for approval! They said it could take up to 5 business days for the approval to come through. We'll let you know when we're notified of any status changes.


In the meantime, you can check out the Windows Phone 8 app page for some screenshots.

If you've tried to access the site over the last couple of weeks you might have noticed some slow load times or even some site outages. We've been trying to figure out what the problem is and have been updating various aspects of the site, server and database to try to increase reliability.

We finally found the root of the issue and fixed it. There should be no unscheduled down-times or overloaded databases now.

Technical Wording Alert...
We knew the issue was database related. We were keeping track of long running queries that would start causing a snowball effect that would eventually cascade into a database overload. All of the queries were coming from the massive 40+million transactions table in our database.

The problem was there was no rhyme or reason to the long running queries behaving the way they did. They would perform fine on some accounts and not at all on others. We used this as a starting point and worked from there.

We initially thought it was a vacuuming issue (basically keeping the table in check for quick access) where the table was too large and the vacuum would die part way through. That's why we took the site down last night to run a full vacuum on the table. Unfortunately, as many of you noticed today, that didn't help. The issues persisted and the database continued to overload.

Fast forward through a lot of high blood pressure inducing brainstorming and we finally realized the transactions table was highly fragmented across our hard drives. All of the adding/deleting of transactions left data all over the place. This meant it took much longer than normal to access all the data quickly and efficiently.

We ended up dumping and reloading the data cleanly and sequentially on our hard disks and that fixed the problem. Everything appears to be fixed now with the transactions table.

Over the next week we'll be conducing the same action on our other large tables to help improve site performance even more.

We'd like to thank you all for dealing with these issues as we've encountered them. I launched ClearCheckbook in 2006 because I wanted everyone to be able to quickly and easily have access to their financial information. Whenever the site goes down I do my best to be transparent and let everyone know what's going on and work to fix the problems as quickly as possible.

ClearCheckbook has grown tremendously over the last few years (we just passed our 250,000th registered user) and we've had our technical hurdles from time to time. Each time we learn something new and work to make sure nothing like that happens again.

Please rest assured that ClearCheckbook is my #1 focus and we're doing our best to provide you with the best money management site and app suite available.

If you have any other questions, please let us know.

Thanks!
-Brandon