Software Affect on Enterprise RDBMS Topic is solved
-
ryuwaraimasa
- Level 1
- Posts: 1
- Joined: Wed Jul 06, 2016 6:53 pm
Software Affect on Enterprise RDBMS
Just curious if the software would work with speeding up the downloading and caching of database files and servers?
-
InquiringMind
- Level SS
- Posts: 477
- Joined: Wed Oct 06, 2010 11:10 pm
Re: Software Affect on Enterprise RDBMS
Welcome to the forums Ryuwaraimasa and sorry about the delayed reply.
As long as you can identify the files used (and indexes particularly) during database queries and have enough spare RAM to create a ramdisk large enough to accommodate them, then general database usage can be sped up (at the very least, relocating the index files on ramdisk should speed up searches and queries).
Download speeds tend to be limited by network bandwidth however, so it is unlikely that Primo Ramdisk could help much there. If you could provide more specific information (database software used, a sample query) then others here may be able to provide more detailed help.
As long as you can identify the files used (and indexes particularly) during database queries and have enough spare RAM to create a ramdisk large enough to accommodate them, then general database usage can be sped up (at the very least, relocating the index files on ramdisk should speed up searches and queries).
Download speeds tend to be limited by network bandwidth however, so it is unlikely that Primo Ramdisk could help much there. If you could provide more specific information (database software used, a sample query) then others here may be able to provide more detailed help.