Recent content by fpullen

> I haven't read anything as to what to consider > towards the "what data" is being stored. Do you > mean one way is better for "writes" and the other is > better for "reads"? No, what I meant was that if you're storing records which are likely to be less than 1KB, then you're possibly...

Hopefully your research includes looking at the application and the actual data stored. For some data, a 1KB block size makes sense. For other, 8KB makes sense. The answer is that it depends. To a certain extent, you're trading off disk space with performance, so it's important to look at...

Eduardo, I hope I'm not too late to help. As you may have already figured out, this particular stget is probably related to a Unix parameter. According to Progress: The MAXUMEM kernel parameter is the user's virtual address space in the kernel. The default value is sometimes...

As to why the checkpoint takes so long, that may be easy: It's writing 16MB. By creating such a large BI cluster, you're basically gambling that Progress can flush dirty buffers into the database faster than the cluster will fill. When you lose, you lose big, in that now 16MB has to be...

A couple of questions come to mind: First, why did you perform a backup, delete the database, then do a restore? I'm not sure this accomplishes anything, except as a rather drastic way to test whether you have a good backup. Second, have you looked at disk fragmentation? It may be that...