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
|
