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