I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community server, utf8 encoding default, it takes 3.38 mins with demo data.
On Wed, Sep 1, 2010 at 5:54 AM, David E Jones <[email protected]> wrote: > > On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: > > > I have two environments: > > 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the > > initial data. > > 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the > > data. > > > > Don't have the solution but I have noticed that on machines with slow > > disks the performance while creating indices, constraints and tables is > > poor. > > Are both machines running the same software, ie same database, JVM, and app > server? How about the same operating system? I've seen this kind of > difference a lot when comparing Linux/OSX/etc to Windows. Windows uses > blocking synchronous IO and is REALLY slow compared to the asynchronous IO > of more server-worthy operating systems. > > -David > > > -- Regards, Varun Bhansaly
