![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Wed, Aug 22 2018 6:13 PM | Permanent Link |
Steve Gill | Hi Tim,
Which tables should I check to monitor the performance of file buffering: * Configuration.FileIOStatistics or * Configuration.ServerSessionStatistics or * Configuration.SessionStatistics Thanks. = Steve |
Mon, Aug 27 2018 3:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Steve,
<< Which tables should I check to monitor the performance of file buffering: >> You want this one: Configuration.FileIOStatistics Tim Young Elevate Software www.elevatesoft.com |
Mon, Aug 27 2018 7:43 PM | Permanent Link |
Steve Gill | << You want this one:
Configuration.FileIOStatistics >> Cool, thanks Tim. ![]() = Steve |
Thu, Sep 6 2018 6:51 PM | Permanent Link |
Jorge Ortiz Rianxeira S.A. | Tim Young [Elevate Software] wrote:
Steve, << Which tables should I check to monitor the performance of file buffering: >> You want this one: Configuration.FileIOStatistics Tim Young Elevate Software www.elevatesoft.com Hello Tim, I share the statistics of my tables, ¿Do you think that the IO Buffers are working as you designed? Everithing is going smooth, we have several thousands of records stored ok with IO Buffers activated, not any issue until now. Good Day! Attachments: StatisticsIO.png |
Mon, Sep 10 2018 4:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jorge,
<< I share the statistics of my tables, ¿Do you think that the IO Buffers are working as you designed? >> Please see my reply here for what to look for: https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=20677#20677 At first glance, the two things that stand out are: 1) You're using the default 4K block size, which is fairly small for larger tables. I typically use 64K blocks for larger tables. Increasing the block size will also improve your avg. write size. 2) You're using the default 8MB buffer allocation for each file, which should be tuned further so that it is larger for the large files, and smaller for the small files. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |