[pilot-db-list] Best practice for big database in pilot-db

[<sva...@qu...>]

Hallo everybody,

I want to know, what is the best practice to prepare this project :

I want to create a dictionary. I have csv file with 3 columns (there is 
a original word, translated word and comment). The length of 1 line is 
no more than 200 chars (50 + 50 + 100). This dictionary has more than 
140,000 lines. When I tried to convert this 7MB csv to pdb, it was 
impossible to convert it. (I´m using DB Editor 0.75 - memory error). 
Therefore I decided to create more databases (for example 4 with 35,000 
lines, but it is still so much)

My last decision is to create 1 main database only with letters (A to 
Z)and links to letter database (letter database contains only words 
starting with one letter). All databses are on SD card.

My question :

1) Is there any possibility to do it easier? (To have database with 
140,000 lines as a whole on memory card, but it should be quick)
2) If I decide to create one main DB with 30 "letter" databases, how to 
hide the letters databases from being visible in start of pilot-db? 
Maybe it should have category other than main database? Any other idea?
3) Maybe there is another solution (I prefer for free). If you know how 
to manage dictionary with +140,000 lines, help me with this.

I have Palm Tungsten T with PalmOS 5 and opening of database with 20,000 
lines tooks about 10 second. It is low but I can live with this.

Thanks for any advice.

Svatopluk Vit
Prague, Czech republic