FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Nightlies Feedback › SVN-1498 Soundbridge Problem › Reply To: SVN-1498 Soundbridge Problem
01/02/2007 at 6:19 PM
#8951
Anonymous
Inactive
@CCRDude wrote:
@pmorris wrote:
If sqlite behaves as other relational engines do, then the Artist list would be served up completely from the index in pre-sorted order without having to read the underlying table.
I guess that depends on the queries used? Doing a SELECT * FROM … wouldn’t have that advantage 😉 But indeed, I just tested, and my Soundbridge can access the DB much faster now 😯 Shiny 😮
Yes, you’re absolutely right. Thank you for making that clarification. I should have said that any query whose result set can be satisfied by an index will experience faster performance.