How to improve performance in the iPhone for iPhone app
I am (still) working on an iPhone program that uses SQLite3. I've managed to optimize the database as much as I can.
Now the problem is that "END OF TRANSMISSION" is killing me as it takes a very long time. The log file is usually around 50k, which might be a problem, but I'd like to know your ideas.
I tried using "PRAGMA synchronous = 0" but it caused some data corruption. My latest optimization attempt is "PRAGMA journal_mode = TRUNCATE" but I don't know if that helps a lot.
Any suggestions at this point?
+2
source to share
1 answer
Have you tried keeping a log in memory?
"PRAGMA journal_mode = MEMORY"
This was one of the most significant performance improvements for us.
If that's not fast enough yet, try memsys5 stuff. http://www.sqlite.org/compile.html#enable_memsys5
+4
source to share