Jump to content


Click the link below to see the new game I'm developing!


Rob Donovan

Member Since 31 Jan 2000
Offline Last Active May 01 2019 05:59 PM
-----

Posts I've Made

In Topic: Text File To .DOCX Or .DOC Converter

08 February 2019 - 09:58 PM

Hi Ross,

 

I've not tried it myself, and not sure if you're running the P4 kernel on Linux, but you could try this... https://askubuntu.co...ia-command-line

 

HTHs, Rob.


In Topic: ischk

29 October 2018 - 01:54 PM

Hi,

 

ischk -v is what you are looking for, I think.

 

I've not got P4 up at the moment, but I think it's the 'Load factor' thing to look for, but test just incase...

 

Rob.


In Topic: cisam FILEDEF change questions

16 May 2018 - 06:58 AM

Yep, that is correct.

 

You will need to write a Lookup / Add Update to convert each file if you change lengths, types or order of any fields.


In Topic: c-isam bcheck -s

16 April 2018 - 09:19 PM

Great! :)

 

I would use compress on indexes, yes.

 

If any external system is also referencing the compressed files, then they should be using the standard C-ISAM routines, which will allow them to access them fine with the COMPRESS flags set.


In Topic: c-isam bcheck -s

16 April 2018 - 12:29 PM

Richard got most of it... :)

 

As for my defrag, this is what it does:

 

Reads the file in key order, and then writes out a new file in that order.

 

What this does is remove any 'deleted' records that haven't been overwritten yet, puts the .dat file in key order so makes accessing seq records quicker (and possibly in the same block read), and reduce the size of the .idx file as it is packed better if its in order and reduces BTREE levels, which makes indexing faster.

 

All of this helps performance and also reduce the size of the files.

 

As far as I am aware, there is no other util that does this, and I would strongly recommend that this is done on the whole system every 6 months or so. (Note: System must be 'offline' to do this)

 

The bcheck -s thing resizes the index node. I looked into this some years ago, and could not find any particular increase in performance changing this. The biggest saving is defragging. 


Click the link below to see the new game I'm developing!