P
pkoufalis
Guest
Monae, Let's stick to one issue at a time. The report execution time is affected by another 100 factors and it will get confusing if we try and address both the original write issue and the new read issue in the same thread. I understand that there is likely overlap in the causes of both issues but it will just get confusing trying to address both. This is what we know and what we do not know: 1. Old machine = some Solaris box with 2Gb Ram (seems unlikely) and 75 Gb HD 2. New VM: Win2K12 20 Gb RAM 2.a) HDD has a capacity of 500 Gb but as I mentioned previously, I DO NOT CARE about capacity. I care about I/O throughput 3. You are loading data and it is slower on the Windows VM 3.a) We DO NOT KNOW how you loaded data. C/S? Dictionary? Bulk? Binary? For the report: 1. Takes twice as long on Windows 2. We DO NOT KNOW DB startup parameters and client connection parameters on Sun vs Windows Paul
Continue reading...
Continue reading...