What is the fastest database?

Jeff Massung massung at gmail.com
Mon Jul 25 18:00:29 EDT 2011


That amount of data is ridiculously small. If you don't care about many
thousands of concurrent connections and having to transform the data set
periodically over time, then SQLite3 is probably the easiest to use, but
really, for that tiny amount of data, *any* database application will work.
I've used Access (from 10+ years ago) with > 1 GB data sets and never had a
performance problem. You just to to make sure you setup the right indexes,
foreign keys, and turn off uniqueness where they really don't matter.

Jeff M.



More information about the use-livecode mailing list