On Mon, Jul 27, 2015 at 1:00 PM, Simon Slavin <slavins at bigfraud.org> wrote:
> > On 27 Jul 2015, at 7:32pm, rotaiv <rotaiv at gmail.com> wrote: > > > Originally, I copied the database file from my PC to my Linux server. I > > thought it might be a carriage return or line feed issue so I recreated > the > > database from scratch on my Linux server. Didn't change anything. > > SQLite is completely platform agnostic. A database file created on any > platform works on any platform. It doesn't care about endline sequences or > where the high and low bytes go. > This assumes the means of copying the file didn't result in CRLF translation of some sort. Still, if the copy process did modify the file in some way, I suspect the problem would have been a corrupt file error, not a slow running query. -- Scott Robison
