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
