Wednesday, November 26, 2003

There is no secret that SQL CE currently is not supported on a Smartphone platform. It means that the options for data storage on a Smartphone for .NET Compact Framework developers are generally limited to DataSet XML serialization/deserialization. This option has known deficiencies: you can read/write data in “all or nothing” way only and XML by itself bloats the data, all of which is a big downsize in the memory constrained Smartphone environment. So, what’s the solution? Write your own “a read from the file stream, save in binary form, fast forward-only reading” storage in CF. And this is what I’ve been working on for the last few weeks. The quick test I ran yesterday showed a really good speed/memory benchmarks. DataGrid population with 1000 (5 fields) records takes about 3 secs! Now, I just need to find some time to clean up the code and write up a whitepaper on it…

11/26/2003 1:52:14 PM (GMT Standard Time, UTC+00:00)  #     |