realbasic-nug
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: RealSQLDatabase text index

from Norman Palardy [Bookmark Link]
To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: RealSQLDatabase text index
From: Norman Palardy <npalardy at great-white-software dot com>
Date: Fri, 31 Mar 2006 00:22:12 -0800
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <JNEMKODMMFHECCENBEECGEFGHHAA dot rblists at rbtips dot com> <20D848F4-4B96-4E03-99B8-DA8A8BE06AD4 at sqlabs dot net> 

On Mar 31, 2006, at 12:04 AM, Marco Bambini wrote:
With the lastest version of SQLite (version 3) and if circumstances are just right, LIKE will use an index. 
See http://www.sqlite.org/optoverview.html#like_opt

---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/


Thanks for the pointer to that page
The LIKE optimization is about what I had expected but couldn't actually see happening in the quick bunch of EXPLAINS I did. 

_______________________________________________
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>
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: RealSQLDatabase text index, Marco Bambini
Next by Date:  RE: RealSQLDatabase text index, Carlos M
Previous by Thread:  Re: RealSQLDatabase text index, Marco Bambini
Next by Thread:  RE: RealSQLDatabase text index, Carlos M
Indexes:  [Date] [Thread] [Top] [All Lists]