A few days back i was having problems searching from my sqlite database. But i would like to hopefully discuss one of those issues today and get your advice and feedback.
My database was approx 40mb in size and in contained some FTS (Full Text Search) tables to enable faster searching for some of my full text queries. This database has been used on other OS platforms and has worked fine, but this database didnt work on my symbian device (Nokia 5800)
Once i deleted the FTS tables my search queries started to work? Even the my '%like%' queries were decently fast.
Anyways my question is...does the sqlite3 library for symbian support FTS? is that why originally my database was not searchable?
Thanks in advance.