What is the fastest database?

[Keith (Gulf Breeze Ortho Lab)]

Hi Jeff,

The thing is is that the database will grow significantly over time. Also, I 
might want to eventually move it online. Therefore, I need the best solution 
to cover all bases for the present and the future...

Thanks,

- Boo

----- Original Message ----- 
From: "Jeff Massung" <massung at gmail.com>
To: "How to use LiveCode" <use-livecode at lists.runrev.com>
Sent: Monday, July 25, 2011 5:00 PM
Subject: Re: What is the fastest database?


> 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.
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>