Hi Simon, On 4/9/2011 12:01 AM, Simon Slavin wrote:
Have you tried speed tests on your platform ? It's hard to tell which will be faster because it depends on what language and OS you're using that interacts with SQLite. So if you have your schema designed and any part of your application written you could try doing lots of information shuffling and see if UTF-8 or UTF-16 is usefully faster than the other. Saving space for your database files may be interesting, but it's useful only if you're short of space, or need faster backups, or something else related. These days most work computers have tons of free space on their hard disks.
No, we have not yet done speed tests actually. We are using SQLite3 from C/C++ on a Windows CE device... so, space is a premium (as is CPU performance actually). Some of the things we are doing are hitting 1.6 ~ 1.8GB in the databases. We're already using CEROD to compress the databases to bring down the disk requirement and that brings it down by around 35%.
We're right now refactoring the database across all its uses and trying to bring down the space required while improving the performance... we've not decided what to do - just exploring ideas that we've collected in the past few weeks.
Cheers, Mohit. 4/9/2011 | 11:20 PM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
