On Mon, Feb 15, 2016 at 9:07 PM, Keith Medcalf <kmedcalf at dessus.com> wrote:
> > On the other hand if you drive either on a road with a speed limit of 30 > miles per hour (and go the speed limit), they both go the same distance in > the same time. > > In other words, inquiring "which gets from one side of town to the other" > the fastest, a Ferrari or an F-150, is not dependent on either the Ferrari > or the F-150, but the infrastructure on which they are travelling. A > similar question would be "which weighs more, a ton of feathers or a ton of > depleted uranium?". > > So the answer is that both SQL Server and SQLite will "travel" at the > "speed limit" imposed by the hardware on which they are run. > On the third hand, how many system resources will SQL Server use to achieve a given level of performance vs SQLite. You don't want a Ferrari or an F-150. You want a Prius. :)