Forum Post: Re: Blocks In Database Buffers Values For Medium To Large Databases

  • Thread starter Thread starter Jimmer
  • Start date Start date
Status
Not open for further replies.
J

Jimmer

Guest
We tried the 08 as suggested, small improvement (11+ min instead of 13) with 8 Million -B. 800,000 in -B is still around 5 min. We are loading programmatically (Create/import), not using proutil load. The thing is that we had an issue with specific modules being slower than expected, so we shrunk down the code to something really simple (like loading a table) and started revisiting the parameters (the first that we modified being -B) so we noticed the 5 min vs 13 min difference. I had opened a case about it and it seems the definitive culprit is Windows (the 64 bit version with its cache management), but I was wondering if anyone had encountered similar situation and if there were any hints on how to tackle/alleviate it. thanks JM

Continue reading...
 
Status
Not open for further replies.
Back
Top