Sponsored Content
Full Discussion: which is better?
Top Forums UNIX for Advanced & Expert Users which is better? Post 302240610 by risk_sly on Friday 26th of September 2008 06:22:26 AM
Old 09-26-2008
which is better?

Hi,

I would like to know which works better in this scenario:

I have a file which contains about 300K to 400K records. This file will be loaded into an oracle table but will be filtered first. I have two ways of doing this.

1st, I filtered the original file and created a new file that contains only the selected records (using awk)

2nd, I included a WHERE clause in the sqlloader control file to filter the records

with these two options, which do you think is more efficient. (some explanations will be much appreciated) thank you.
 
GETDS(1p)						User Contributed Perl Documentation						 GETDS(1p)

NAME
getds - Create a DS record from DNSKEYing information SYNOPSIS
getds <domain> DESCRIPTION
getds will create a DS record from DNSKEYs for the specified DNS domain. It does this by converting DNSKEYs to DS records using the specified hashing algorithm. The results can then be passed to upstream DNSSEC-supporting parents or to DLV registries. getds will also pull the parent's published DS records and compare them against the existing keys. It will then list any DS records not published in the parent, as well as any DS records that are published in the parent but which don't match an existing key. OPTIONS
getds takes the following options: -a ALGORITHMS --hash-algorithm algorithm ALGORITHMS This option specifies the hash algorithm to use when converting DNSKEYs to DS records. It may be a comma-separated list if multiple algorithms are desired. The algorithms to choose from may be either SHA256 or SHA1. The default is SHA256,SHA1 -z --print-zsks This option causes getds to print ZSK DS records, as well as KSK records. -p --dont-check-parent Instructs getds to not check the records in the parent for their published DS records. -q --quiet Produces quiet output with no explanatory headers. In other words, it only prints the DS records generated from the DNSKEYs. Note: Running with -q implies -p. SECURITY CONSIDERATIONS
By default, getds pulls data from the live DNS. If your DNS resolver isn't configured so that this is pulled securely, then the results can't be trusted. COPYRIGHT
Copyright 2008-2012 SPARTA, Inc. All rights reserved. See the COPYING file included with the DNSSEC-Tools package for details. AUTHOR
Wes Hardaker, hardaker AT AT AT users.sourceforge.net perl v5.14.2 2012-06-21 GETDS(1p)
All times are GMT -4. The time now is 07:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy