Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Tune my query
Top Forums Shell Programming and Scripting Tune my query Post 302342870 by senthil.ak on Tuesday 11th of August 2009 02:17:05 AM
Old 08-11-2009
Lightbulb Tune my query
I have a requirement to separate only some numbers from the input file and produce it in a format.
The input is ( i have took a sample, the actual file contains more than 50000 rows around 840 MB in size)
Code:
$cat temp.txt
001 08  002 08  003 06  004 11  005 11  006 08
007 08  008 92* 009 92  010 92  011 92  012 92
013 92  014 92  015 92  016 92  017 92* 018 92

I use the script like below
Code:
awk '{for(i=1;i<=NF;i=i+2) {x =i+1; print $i,$x ; print "\n";}}' temp.txt | awk '/*/ {print "substr($2,1,2), $1}'
 
The output is
92 008 
92 017

Could you please tune my script which will have only one awk or some other commands. Appriciate your help on this.

Thanks
Senthil ak.
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Tune my logic of script

I have big log file, which contains the netstat output from my application server to a particular DB server. I aim is to plot a daily graph for this. Please find the sample log file below. @ - ........................................................... @ - Total number of connection to the ... (3 Replies)
Discussion started by: senthilkumar_ak
3 Replies

2. Cybersecurity

How to fine Tune and Harden the Linux kernel

Hi, As a a security audit, how can I proceed further with Fine tuning and Hardening the linux kernel... I am not sure with the steps how to proceed further... If i do some thing wrong, then its comes with the Kernel panic error. So, I am afraid, how to do the tuning with the kernel.. (1 Reply)
Discussion started by: gsiva
1 Replies

3. Solaris

Please tune my script for Solaris

I have very big log file around 2-3 GB in that it contians 24 hours log data. My work is extract only 5-5 data and count the patterns from them. I worte a script in linux and we're using that. sed -n "/2009 05:/,/2009 17:/p" trace.log | grep -f patterns.txt > temp.log while read string ;do... (5 Replies)
Discussion started by: senthil.ak
5 Replies

4. UNIX for Dummies Questions & Answers

Need tune my command occupying 90% CPU

Can some body tune the below command, its occupyinh more than 90% of CPU some times. tail -n 1000 /logs/trace.log | awk 'BEGIN{OOM = 0; ScE = 0; NaE = 0; Jms = 0} /OutOfMemoryException/{OOM = 1} /StaleConnectionException/{ScE = 1} /NamingException/{NaE = 1} /JmsTimeOutException/{Jms = 1}... (17 Replies)
Discussion started by: senthil.ak
17 Replies

5. Programming

SQL : Fine tune Insert by query

i would like to know how can i fine tune the following query since the cost of the query is too high .. insert into temp temp_1 select a,b,c,d from xxxx .. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies

6. Shell Programming and Scripting

Fine Tune - Huge files/directory - Purging

Hi Expert's, I need your assitance in tunning one script. I have a mount point where almost 4848008 files and 864739 directories are present. The script search for specific pattern files and specfic period then delete them to free up space. The script is designed to run daily and its taking around... (19 Replies)
Discussion started by: senthil.ak
19 Replies

7. HP-UX

Top cmd showing NICE value 97% -what to tune?

Running 2 VM Guests on an HPUX Integrity Server. One Guest runs great, the other is always at a high NICE value and 0% idle as shown in TOP: What do you think should be tuned to bring down the NICE and increase IDLE %? Thanks in advance -hpuxadmin slow VM GUEST Load averages: 2.56,... (5 Replies)
Discussion started by: hpuxadmin
5 Replies

8. Shell Programming and Scripting

Tune my script

Hi ! My script read out data out of 144 files per day - every ten minutes a file with data. data-file WR030B 306.71 0 WR050B 315.13 0 WR120B 308.34 0 WV030B 3.52 0 WV050B 5.06 0 WV120B 6.65 0 TLUFT02B 8.60... (3 Replies)
Discussion started by: IMPe
3 Replies

LEARN ABOUT MINIX

ascii

ASCII(7)						 Miscellaneous Information Manual						  ASCII(7)

NAME

       ascii - the ASCII character set.

DESCRIPTION

       The ASCII character set is as follows:

       |000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel|
       |010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si |
       |020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb|
       |030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us |
       |040 sp |041  ! |042  " |043  # |044  $ |045  % |046  & |047  ' |
       |050  ( |051  ) |052  * |053  + |054  , |055  - |056  . |057  / |
       |060  0 |061  1 |062  2 |063  3 |064  4 |065  5 |066  6 |067  7 |
       |070  8 |071  9 |072  : |073  ; |074  < |075  = |076  > |077  ? |
       |100  @ |101  A |102  B |103  C |104  D |105  E |106  F |107  G |
       |110  H |111  I |112  J |113  K |114  L |115  M |116  N |117  O |
       |120  P |121  Q |122  R |123  S |124  T |125  U |126  V |127  W |
       |130  X |131  Y |132  Z |133  [ |134   |135  ] |136  ^ |137  _ |
       |140  ` |141  a |142  b |143  c |144  d |145  e |146  f |147  g |
       |150  h |151  i |152  j |153  k |154  l |155  m |156  n |157  o |
       |160  p |161  q |162  r |163  s |164  t |165  u |166  v |167  w |
       |170  x |171  y |172  z |173  { |174  | |175  } |176  ~ |177 del|

       |00 nul|01 soh|02 stx|03 etx|04 eot|05 enq|06 ack|07 bel|
       |08 bs |09 ht |0A nl |0B vt |0C np |0D cr |0E so |0F si |
       |10 dle|11 dc1|12 dc2|13 dc3|14 dc4|15 nak|16 syn|17 etb|
       |18 can|19 em |1A sub|1B esc|1C fs |1D gs |1E rs |1F us |
       |20 sp |21  ! |22  " |23  # |24	$ |25  % |26  & |27  ' |
       |28  ( |29  ) |2A  * |2B  + |2C	, |2D  - |2E  . |2F  / |
       |30  0 |31  1 |32  2 |33  3 |34	4 |35  5 |36  6 |37  7 |
       |38  8 |39  9 |3A  : |3B  ; |3C	< |3D  = |3E  > |3F  ? |
       |40  @ |41  A |42  B |43  C |44	D |45  E |46  F |47  G |
       |48  H |49  I |4A  J |4B  K |4C	L |4D  M |4E  N |4F  O |
       |50  P |51  Q |52  R |53  S |54	T |55  U |56  V |57  W |
       |58  X |59  Y |5A  Z |5B  [ |5C	 |5D  ] |5E  ^ |5F  _ |
       |60  ` |61  a |62  b |63  c |64	d |65  e |66  f |67  g |
       |68  h |69  i |6A  j |6B  k |6C	l |6D  m |6E  n |6F  o |
       |70  p |71  q |72  r |73  s |74	t |75  u |76  v |77  w |
       |78  x |79  y |7A  z |7B  { |7C	| |7D  } |7E  ~ |7F del|

																	  ASCII(7)
All times are GMT -4. The time now is 02:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy