Thread: Searching for format- format vs formats vs approximate formats?
View Single Post
Old 01-02-2014, 12:46 PM   #3
unboggling
Wizard
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,065
Karma: 858115
Join Date: Jan 2011
Device: Kobo Clara, Kindle Paperwhite 10
Quote:
Originally Posted by theducks View Post
You don't have SQLite database browser (or equiv)?
I was hoping experts would just know the answers off the top of their heads. I do have a database browser. When I use SQLiteStudio I crash frequently. Before asking the question here I upgraded to newest version of SQLiteStudio then crashed again, twice. So I'm leery of using that now and need to find something that works better on OS X 10.9.1. Anybody have any recommendations?

Quote:
Originally Posted by theducks View Post
the format is stored in the 'data' table. That field is also Indexed (formats_idx)
Before crashing, I noticed formats_idx is based on "format".

The question still is: which search is faster and why?
unboggling is offline   Reply With Quote