Android Question SqlLite slow?

GaryK4

Member
Licensed User
Longtime User
I am playing around with a Jumble solver program as a learning exercise. I wrote the program in Visual studio first. A word with 7 characters is solved in .02 seconds and 8 characters in .14 seconds.
On Android, 5 char = 3 sec, 6 = 16, 7 = 50 and 8 characters, I gave up after 10 minutes.
The program uses a one field database containing a 60K word dictionary and indexed. It then takes all the permutations of the jumble (length factorial) and queries the database. The found, non-duplicate words are then displayed.
PC ~ 250,000 records / second.
Sqllite ~ 100 records / second.

Does this seem correct or an I doing something wrong?
 

GaryK4

Member
Licensed User
Longtime User
SQLite engine is part of the Android OS. It is also the same engine as you have in every other platform. The I/O itself is slower as devices are slower.

OK Thanks.

And thanks again for the very creative hash solution. It works great!
This was a learning exercise and it more than met my expectations :)
 
Upvote 0
Top