AW: Sql nested set from dictionary

Hi Ryan,

Thank you for the tip. I wish however to resolve this as quick as possible - and without any hassle.

I have already started mashing some code together and hopefully I'll get this done myself.

Thank you,
BR,
Adrian

PS Thing is, I have 2 databases that will use this feature. One sqlite on a mobile device and an mssql from a web service. So I would need some common code and database structure.





________________________________
Von: Ryan Heath <[email protected]>
An: [email protected]
Gesendet: Mittwoch, den 16. Juni 2010, 17:23:01 Uhr
Betreff: Re: [OT] 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@ yahoo.com> 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
>
>