If reccount is missing in dump, is this important? (OpenInsight Specific)
At 02 OCT 2001 12:29:55AM rayc@symmetryinfo.com wrote:
This may be a non-issue, but I would appreciate any comments.
I looked at some AREV files that were brought over to OI for our conversion effort. Several of these files are lacking the RecCount. That is, when you go to dump (in Arev), there is no Reccount. These files were made before RecCount was part of the Linear Hash file structure (ARev 2.0x or earlier??).
I could easily just remake these files in AREV and copy them over to OI so that they will have the RecCount. With the Reccount missing, however, will this affect any operation or procedure in OI. I know that
Cnt=Get.RecCount(FileHandle,flag,0
will return a zero. That's how I stumbled on this. Could there be other things affected.
Just curious,
Ray
rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"
Ray Chan ~ Symmetry Info
At 02 OCT 2001 06:12AM Oystein Reigem wrote:
Ray,
I've had problems with the record counter, so I don't trust it. Perhaps I'm just stupid. Do a Site Search for
oystein and "get.reccount"
and judge for yourself.
- Oystein -
At 02 OCT 2001 08:56AM Don Miller - C3 Inc. wrote:
Ray .. Oystein
The record counter is stored in the header of an LH file. It is useful to validate such things as index corruption (a B-Tree that indexes all records should match the record counter +- 1 depending on whether a Quickdex/Rightdex is installed). You can update the record counter by doing an R/LIST select on the table (either in Arev 3.12 or in OI) on a non-indexed field. If it is missing entirely, you can have troubles in any process that uses the Get.Reccount function without an implicit select.
Don Miller
C3 Inc.
At 02 OCT 2001 09:17AM Matt Sorrell wrote:
Ray,
Using Get.RecCount the way you are:
Cnt=Get.RecCount(FileHandle,flag,0)
just reads the record count info from the header.
Instead, if you use:
Cnt=Get.RecCount(FileHandle,flag,1)
that will force the system to count the records in the table. Definitely slower, but more accurate as it physically counts each record in the table.
msorrel@greyhound.com
At 02 OCT 2001 09:49AM Simon Wilmot wrote:
Ray,
just as a matter of interest - what does Get_LH_Info return for these tables ??
Simon
RebusHR
At 02 OCT 2001 04:28PM rayc@symmetryinfo.com wrote:
Oystein, Matt, and Don
Thanks for the help. I guess based on the response the only negative impact in not having the Reccount in the LH file is Get.Reccount and some select. Therefore, I'm pondering if it's really worthwhile to do a recordcopy to a new file so that I and "client-sites" will have Reccount in all Files.
Ho-humm,
Ray
rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"
Ray Chan ~ Symmetry Info