[sqlite] index creation 30x slower on Mac than on Linux

2013-04-24 Thread Alan Frankel
We're using SQLite to manage a roughly 250Mb database on both Linux and Mac. In order to make our lookups fast, we're creating an index table in the database. On Linux, creating the table takes about 200 seconds. On the Mac the same operation takes 6,400 seconds. Here's the CREATE INDEX

Re: [sqlite] index creation 30x slower on Mac than on Linux

2013-04-24 Thread Simon Slavin
On 23 Apr 2013, at 4:58pm, Alan Frankel alan.fran...@mathworks.com wrote: We're using SQLite to manage a roughly 250Mb database on both Linux and Mac. In order to make our lookups fast, we're creating an index table in the database. On Linux, creating the table takes about 200 seconds. On

Re: [sqlite] index creation 30x slower on Mac than on Linux

2013-04-24 Thread Stephan Beal
On Tue, Apr 23, 2013 at 5:58 PM, Alan Frankel alan.fran...@mathworks.comwrote: ...Why is the Mac 30 times slower than Linux? They're both on the same network, accessing the same network drive location, so neither has the advantage of local disk access. i'm speculating, but i have seen (on