Reply To: mt-daapd 1005, song lenght


@fizze wrote:

Ok, I’ll give it a shot once Im home.
In fact this looks nice, as it can strip/convert case of tags as well.

Wouldnt it be kinda cool to have the mt-daapd DB be case insensitive ?
wouldnt be to hard to add a few UPPER() or LOWER()’s in the queries, would it ?

I could go either way on that. Like queries on mysql are already insensitive, so if everything was, I wouldn’t argue with that.

I just took a peek at db-sql.c, its where the browse magic happens, right ?
Being an Oracle guy I donno much about the features sqlite3, or the other backends, but I think those queries could be sped up.
Things like the double selects to get the count can be acheived by %%rowcount or cols, given sqlite3 supports that.

Yeah, but in the case of an indexed search I need not the rows returned, but the total rows without the offset/limit.

Also, it has to work with sqlite, mysql, and postgres at a minimum, which means sql-92 only.

If you can come up with performance enhancements that meet that criteria, I would certainly welcome them. I’m not much of a sql guy. Enough to hack about a bit, but by no means a dba.

As far as the slug goes, I want to add back the gdbm backend before a 1.0 release — it’s far snappier than sqlite on the slug.

— Ron