At 2:16 PM -0700 22/11/06, Norman Palardy wrote:
On Nov 22, 2006, at 1:42 PM, Dr Gerard Hammond wrote:
Hi,
When I do a SQLselect and search for a fragment of a string in a
text field, will the SQLselect actually search the entire contents
of my TEXT and BLOB columns.
ie is full-text search builtin?
you can get it to but it does not seem to be indexed in any way that
makes it run faster
if you do
like '%something%'
on a big blob or text it can still take a while
Thanks. Now I understand. full-text search = indexed full text search.
I was certain that I had found strings in my TEXT fields. Know I see
that I was doing an exhaustive full scan of the blob field.
That's okay as it works fairly fast as is. I also understand that
'indexed full text searchs' will be apart of SQLite soon, so the
future looks even better for the REALSQL.
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
