Hi Simon, No, I don't need it... but someone else might. I was considering adding FTS3 to my library in case someone needs to search across several text records. Depending on the table size, LIKE or GLOB would be very expensive because doing a full table scan would not be the most optimal approach, even if the database is not that large on an iPhone.
To be honest, it's more of a curiosity than actual need. I would not add it until it was needed, but I'd like to know what lies ahead. Thanks Simon, -- Tito On May 16, 2011, at 8:26 AM, Simon Slavin wrote: > > On 16 May 2011, at 4:06pm, Marco Bambini wrote: > >> 4.3 MB seems really too big... you are probably building a debug version of >> the library. > > Agreed. I don't know what's wrong but nothing should take 4Meg. > > Also, do you really need FTS3 ? Try a simple search using LIKE or GLOB. > With the small amount of data your app will have (since it has to fit within > an iPhone anyway), is your search really too slow for normal use ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
