Apps Script & Java Script

Measuring sheet operation performance

Looking into how various operations perform as the size of the sheet increase provided some interesting data. The objective is to see whether the time to execute particular operations is directly proportional to the size […]

No Picture
Docs Specific

Getting insights into Sheets performance

Here’s a general purpose timer for wrapping functions without having to edit them to put timers around them. This is something I often have to do if tracking down performance problems, so I thought I’d […]

Docs Specific

Using array formulas to improve performance

In Getting insights into Sheets performance I mentioned that I was taking a look under the covers of Sheets to see how performance is doing and introduced a useful function for timing stuff. The first […]

Database abstraction

Relative performance

Some information on performance when using the DataStore back end in Database abstraction with google apps scriptThe library reference is  Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j   Comparing scriptDB, parse and datastore In Migrate data from scriptDb to Datastore I showed how to copy […]

No Picture
Database abstraction

Back end performance linearity

Some information on performance of each of the back ends in Database abstraction with google apps script The library reference is   Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j Comparing linearity In Relative performance I covered performance of scriptDB versus Parse versus DataStore.  Overall, Parse […]

Database abstraction

Comparing all back ends performance

Some information on performance of each of the back ends in Database abstraction with google apps script The library reference is  Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j   Update – I’ve added Driver MongoLab since these original tests were made. For a more […]