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