I have a 2013 Macbook Pro with 16 Gig RAM and a 1 Terabyte SSD.  So not entirely wimpy, but nowhere near as fast as the current Macbooks, I have no idea how that compares to a typical laptop these days.  Most things run fairly quickly, but inserting 2.5 million attributes into a document takes perhaps 5 hours, I didn't time it.  I can run that overnight, and do test runs on smaller subsets, but I want to think through my options.

Jonathan

On Sat, Feb 19, 2022 at 6:11 PM Liam R. E. Quin <liam@fromoldbooks.org> wrote:
On Sat, 2022-02-19 at 16:05 -0500, Jonathan Robie wrote:
> If I am running my queries and updates on a typical laptop, would
> they run much faster if I ran them on a suitably configured instance
> in the cloud?

"suitably configured" is very subjective.  Potentially your queries
could run a lot faster.

A lot depends on the speed of the disk (or SSD) in the laptop, and the
amount of memory it has, as well as the CPU - a recent Macbook Pro will
be faster than a ten-year-old chromebook.  However, server blades (the
machines used in data centres) typically have much higher bandwidth
between memory and devices including both the CPU and the long-term
storage, and likely have more physical RAM than your laptop.

On the other hand, connecting over the network to the cloud can be
slow....

Liam

--
Liam Quin, https://www.delightfulcomputing.com/
Transformers team, Paligo.net

Pictures from old books - www.fromoldbooks.org