On 8 Mar 2011, at 3:22pm, Gigin Jose wrote: > Is the system supposed to take this amount of time on a ARM base embedded > device ? Is there any better way to extract data ?
You will have a number of caches involved in the setup, and the caches are different sizes on the different devices. Since your database is only 2.6meg in size, it's possible that the entire database file has been cached on your desktop computer. This is very common. Also, SQLite may be using less memory on your ARM device than it is allowed to use on your desktop computer. One thing you might want to change is the page size of your database. This is set automatically when the database is created. So if you want best performance on your ARM device, it can be useful to make the database on that device, just create a table with no data in it. Then you can move the database to your computer and put data in it, but the page size will stay the same, still optimized for the ARM device. For a little more information see http://www.sqlite.org/pragma.html#pragma_page_size Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
