Your browser is no longer supported! Please upgrade your web browser now.
Posts by Zach Moazeni:

A Gift of Time

Seasons greeting! As the year winds down, I’d like to share some improvements I’ve made to our database this year. You may not have noticed them, but you’ve probably felt them when you run reports or load pages in Harvest. Many Harvest pages should feel much snappier!

Last year we were unhappy with how long it took for several of our reports to retrieve data from the database. We have monster database servers, so we knew hardware wasn’t the issue. But still, we saw large projects could wait on data up to 12 seconds, making page renders and refreshes noticeably slow. This issue grew worse for our customers when we redesigned our Projects section to incorporate more reporting, which ran several slow queries next to management actions.

Over the years we’ve tried several strategies to improve our performance, including caching report information. However, we prefer to show you the most up-to-date data whenever possible, and some projects are so active that the cached data doesn’t last long anyway.

The problems with data retrieval and poor load times boiled down to the way we store and retrieve your reporting data. There was no simple fix, like adding a missing database index or moving to a different technology stack. Instead, we precomputed key project report details and eliminated all SQL JOINs from our report. In the coming months I’ll post more details about these changes to our technical blog, Techtime, so stay tuned to that blog if you’re interested in the nitty gritty details!

Remember that 12-second report I mentioned earlier? With our database improvements it now runs in about 1.5 seconds. That may not seem like a lot, but when you’re a manager going through different projects, and each project page can run several queries, that time adds up. Saving 10 seconds for a project manager who checks on only two project reports a day saves them an extra two hours a year! That’s two hours they would have wasted waiting on a spinner for the page to load.

You may not have noticed these improvements to make your reports snappier unless you were paying close attention. But, we consider that a success! One of the key goals of this project has been to make improvements without disrupting you. This means our database maintenance, report verification, and performance rollout have taken significant thought and planning to ensure you could continue to use Harvest without interruption

This was a difficult post to write, because for you, my work has been nearly invisible. There are no new features to use, buttons to press, or reports to run. But, your experience in Harvest is now faster and smoother. Though you may not see a difference, you may feel one. We’re happy you’ll be spending far less time in Harvest, and more time doing the things that matter.

Scheduled Maintenance, Monday November 4th 10:00pm – 10:15pm EST

We’re making some database changes to Harvest. To make sure we don’t timeout any critical tasks, we are planning on taking Harvest offline November 4th 10:00pm – 10:15pm EST while we perform these changes. What time is that for you?

Thank you for your support. We will keep our progress up to date on @harvest and HarvestStatus.

UPDATE: Maintenance has now been completed successfully at 10:20 PM EST. Everything is operating normally again. If you experience any problems, try clearing your web browser’s cache and reloading the page you’re on.  If you need assistance with this, or with anything else, please drop us a line at support@harvestapp.com. Thank you!

Xero and Harvest: No More Copy & Paste

Update: We’ve been awarded Xero’s Add-on Partner of the Year for 2013. Thank you for your support!

Great news! We are excited to announce a new integration with Xero, a popular online accounting platform. You can now have invoices automatically copied from Harvest into Xero for your accounting records. You can also manually copy any unsent or updated invoices by using a simple drop down menu right from an invoice.

With both Harvest and Xero at your disposal, it’s now possible to streamline your business processes from start to finish. Track project time and budgets as usual in Harvest. Then invoice off the tracked time with one-click in Harvest. The invoice is copied over to Xero via the integration.

In Xero, financial transactions are pulled from your bank accounts so you can run reconciliation, payroll, and keep an accurate picture of cashflow.

To set up the integration, just go to Account Settings in Harvest and select Connect to Xero. You’ll then be sent to Xero to confirm the integration. That’s all there is to it. From Xero, you can easily jump back to Harvest to see your original invoices.

For more information, watch the video below or check out our Help Center.

Special thanks to all of our beta testers and the team at Xero for making this integration go so smoothly.