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