Re: Sql nested set from dictionary

Hi,

Maybe a Lucene index is more appropriate for your problem?

We have recently moved from sqlserver fultext search to a lucene index and
we will never look back ;)

http://lucene.apache.org/lucene.net/

// Ryan

On Wed, Jun 16, 2010 at 2:53 PM, Adrian Vintu <adrianvintu-/[email protected]> wrote:

>
>
> Hi all,
>
> I have a read-only dictionary of ~2 million words.
>
> They are now stored in an Sqlite database like this
>
> Table WORD
> ID WORD     POINTER_TO_DATA
>
> 1  bla      207
> 2  next     135
> 3  example  1234
> 4  other    3457
> ...
>
> Using this non-tree way of storing the words kills my system when doing a
> SELECT LIKE 'word%' - think mobile.
>
> I would need a script(SQL, Java, C#, Python, etc) to create a tree out of
> the structure, or even better, a nested set like here
> http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
>
> Any help would be greatly appreciated.
>
> (I have googled around, but I am not even sure what the keywords are...)
>
> Thank you,
> Best regards,
> Adrian Vintu
>
>  
>