Sql nested set from dictionary

Adrian Vintu <adrianvintu-/[email protected]>
Newsgroups gmane.comp.windows.off-topic
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.