Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Caching |
Wed, Oct 3 2007 9:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | How about a switch to say cache the whole table - to be used responsibly of course. I'm mainly thinking of smallish lookup tables in a fileserver scenario so I don't have to figure out how big they might be but would like them fully in ram.
Roy Lambert |
Wed, Oct 3 2007 10:22 AM | Permanent Link |
Dave Harrison | Roy Lambert wrote:
> How about a switch to say cache the whole table - to be used responsibly of course. I'm mainly thinking of smallish lookup tables in a fileserver scenario so I don't have to figure out how big they might be but would like them fully in ram. > > Roy Lambert Roy, Are you referring to EDB or DBISAM? What happens when you have two users one who want 500MB for the table cache and the other who wants only 25k? I think that's why EDB insists on putting the buffers in the table definition. Dave |
Wed, Oct 3 2007 10:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Dave
> Are you referring to EDB or DBISAM? ElevateDB >What happens when you have two >users one who want 500MB for the table cache and the other who wants >only 25k? I think that's why EDB insists on putting the buffers in the >table definition. That's why I said fileserver Roy Lambert |
Thu, Oct 4 2007 11:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< How about a switch to say cache the whole table - to be used responsibly of course. I'm mainly thinking of smallish lookup tables in a fileserver scenario so I don't have to figure out how big they might be but would like them fully in ram. >> Just simply make the buffer sizes for the table(s) larger than the estimated max size of the table. That will ensure that they are always buffered entirely in memory. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, March 27, 2024 at 05:29 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |