"Dima Dat'ko" <[EMAIL PROTECTED]> wrote: > Thank you Dennis for your answer. I proceed with playing with the issue. > > To whom it might be interesting here are timing results for a simple > function demonstrating the problem (please see the code bellow). > > sqlite version | flash card type | time from (1) to (2) [milliseconds] > -------------------+----------------------------+------------------------------------------------------ > 3.4.2 | SD SanDisk (fast) | 4335 > 3.4.2 | CF Toshiba (slow) | 4401 > 3.5.6 | SD SanDisk (fast) | 43993 > 3.5.6 | CF Toshiba (slow) | 79568 >
Have you tried this on 3.5.7? I think it should be back to begin as fast or faster than 3.4.2. Another thing you might try is using UPDATE OR FAIL instead of just UPDATE. Note also that the enhancements for version 3.5.7 and UPDATE OR FAIL are cumulative. So you should get even better performance if you do both. -- D. Richard Hipp <[EMAIL PROTECTED]> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
