iTunes has "update search results as you type" speed even when you have a hundred thousand songs and you're searching on a partial string on all meta data columns.
how on earth do they do that? i'm under the impression it uses CoreData, which in turn uses SQLite under the hood. how can i make my partial string searches searches thru multiple columns go that fast? FTS seems to imply it can make things blazing fast. is that really true? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
