KSAM file performance

[Jon Hawks]

Also, if you sort the flat file by the primary key before reloading KSAM, you should gain some speed.
Some coached people to keep each KSAM file to 3 x indexes, some would claim 6 and well, you can see where all that leads.
 
Also, with qtp, it does maintain its own rollback, even on a ksam.  sometimes it was easier to process flat files in quiz, output a subfile, and then load that via qtp.  depends, right?
 


________________________________
From: "vical1 at eastlink.ca" <vical1 at eastlink.ca>
To: powerh-l at lists.sowder.com 
Sent: Wednesday, July 11, 2012 1:11 PM
Subject: Re: KSAM file performance

Ken, I'm not sure which "version" of KSAM files you're using, but for older versions, we had to periodically re-load the files--the details of why escapes me, but I believe there were a number of factors that caused KSAM to grind to a halt.

You should reference you HP3000 manual for instructions, but if memorry serves, we FCOPY'd the data out to a flat file, deleted the KSAM files (after a backup or two!) and re-created them, and then copied the data back in.  This re-organizes your keys and physically deletes any logically deleted records.  

Again -- going on memory here from almost 20 years ago, but I suspect that could be your issue.  They were notorious for performance degradation unless regularly re-built.  Some newer version of KSAM were better, but could still slow down over time.

Hope this is helpful!

Vicki Robertson

Sent on the TELUS Mobility network with BlackBerry

-----Original Message-----
From: powerh-l-request at lists.sowder.com
Sender: powerh-l-bounces+vical1=eastlink.ca at lists.sowder.com
Date: Wed, 11 Jul 2012 12:00:03 
To: <powerh-l at lists.sowder.com>
Reply-to: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 85, Issue 2

Send powerh-l mailing list submissions to
    powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
    powerh-l-request at lists.sowder.com

You can reach the person managing the list at
    powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."


Today's Topics:

  1. FW: Access KSAM files with QTP is really slow (Ken Langendock)


----------------------------------------------------------------------

Message: 1
Date: Wed, 11 Jul 2012 11:47:14 -0400
From: "Ken Langendock" <ken.langendock at rogers.com>
Subject: FW: Access KSAM files with QTP is really slow
To: "'power-l'" <powerh-l at lists.sowder.com>
Message-ID: <000901cd5f7c$7182bfb0$54883f10$@langendock at rogers.com>
Content-Type: text/plain; charset="us-ascii"

Hello all, 



I am in the process of extracting data from an HP3000 and ran into something
that I have never seen before.

When I extract data from KSAM files, the process grinds to a halt
practically, the IMAGE files are fine.



I used to use KSAM all the time and never saw any performance problems
before like this.



Any ideas would be appreciated.



Ken

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/c1ace754/attachment.html>

------------------------------

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

End of powerh-l Digest, Vol 85, Issue 2
***************************************
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120713/495fcd4c/attachment-0001.htm>