On 23 Jul 2010, at 12:22pm, Black, Michael (IS) wrote: > #1 Are you using the same database file on both Windows and Linux or are you > creating it independently on each? I'm wondering if your Windows system is > fragmented (much more likely than your Linux system is to frag). How full is > the disk that your database is on and have you defragged that disk? > #2 How long does your fread program take to run? If must be much less then > 40 seconds I would imagine. > #3 How long does "select * from mytable" take when it's the first thing you > run on both Linux and Windows? > #4 Have you tried changing your caching to "System Cache" instead of > "Programs" jsut to see what happens?
Change the extension of the file from .db to .sqlite or something else. Windows treats .db files in a special way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
