What is the fastest database?

[Jeff Massung]

If you are thinking web and growing for the future, then it's hard to beat
PostgreSQL, which also comes with some nice web-admin tools for viewing the
database, etc. MySQL - I hear - is equally nice, but I haven't used it.

You may just want to quickly test your work with SQLite3, which is
near-identical to MySQL as far as query syntax goes, and if you think you
like it, then migrate to using MySQL.

I also recommend downloading Navcat Lite as a tool for viewing whatever
database you decide to use. It's very handy.

Jeff M.

On Mon, Jul 25, 2011 at 4:07 PM, Keith (Gulf Breeze Ortho Lab) <
keith at gulfbreezeortholab.com> wrote:

> 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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>>
>>
>
> ______________________________**_________________
> 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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>