Quote:
Originally Posted by opetopic
Hey, I just looked at your numbers... that definitely does not look right. Post your table schema.
|
Hi opetopic,
Thanks for your help
The numbers is not for just grabbing the 100 words from the database. It initializes variables among other things. For those tests, I've kept everything the same except changing the database size to see how it would affect speed.
I use two SQLite files, one is for dictionary and the other for word selection that has been randomized. I randomized the second database of words so the iPhone doesn't have to do this processing, just select a chunk of word from a randomly chosen starting index. Would it be better to combined the randomized table into the dictionary table as another column?
I know this will increase the size.
The Dictionary database is the one I send queries to.
I use Sqlite Manager pluggin for FireFox to create my Sqlite database.
I choose to import the cvs file then give it a table name "EnglishD"
then selected "First row contain name columns" and left everything default.
I then clicked okay. it then ask me if i want to modify it. I click okay.
Under Define column, my column names are
word and
length
I change the
data type to TEXT, should I make this int? any gain in performance?
There is an option for "allow null", should I check that or not? I left it default as checked.
I then created an index and selected "Ascending" for both columns.
I guess my schema would be a column of unique words shorted in ascending order and another column with length also sorted in ascending order.
Is it acceptable for me to post sqlite file on this forum?
Thanks for all your help,
-FerrariX
