MySQL and Amarok
ian at monroe.nu
Sat Sep 30 04:31:34 UTC 2006
On 9/29/06, Greg Meyer <greg at gkmweb.com> wrote:
> On Friday 29 September 2006 8:48 pm, Seb Ruiz wrote:
> > On 30/09/06, nikosapi <nikosapi at gmail.com> wrote:
> > > Is there an advantage to using MySQL instead of sqllite? (just
> > > curious...)
> > It's much, much faster.
> Well, I am not sure about that. Muesli and I tested this pretty extensively
> about 18 months ago and sqlite actually came out on top in terms of speed of
> returning query results, even on pretty big collecitons (mine has 5,000
> tracks). It might be worth testing again.
It wouldn't surprise me really. There is some overhead from
interprocess communication, thats one of the advantages of in-process
databases like sqlite.
More information about the Amarok