What is the fastest database?

Pete Haworth lists.pete at haworths.org
Mon Jul 25 18:29:56 EDT 2011


All good stuff.  SQLite is great for prototyping applications and in
production use for single user applications, but it will have problems
dealing with networked file access and/or a high volume of multi-user
updating activity (due to locking issues).

Pete



On Mon, Jul 25, 2011 at 3:13 PM, Jeff Massung <massung at gmail.com> wrote:

> 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>
> >
> _______________________________________________
> 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
>



More information about the use-livecode mailing list