[TriLUG] Awk question

[Lance A. Brown]

Mark Freeze wrote:
> When 'sort' gave us this type of performance we started looking for a
> way to speed up the packet summarization (Did I just create a word?)
> step.  MySQL is currently taking around 5 hours to analyze and
> summarize around 40,000 records into 15,000 records.  A friend of ours
> said that he thought that a combination of sort and awk would perform
> this task without a hitch.  (The only hitch being that I don't know
> anything about awk.)

Gracious.  Sounds like you desperately need some indexes on your tables.
 No way should that work be taking that long.  Have you analyzed what
you are doing and applied appropriate indexes to the mysql tables?

--[Lance]
-- 
 Celebrate The Circle   http://www.celebratethecircle.org/
 Carolina Spirit Quest  http://www.carolinaspiritquest.org/
 My LiveJournal  http://www.livejournal.com/users/labrown/
 GPG Fingerprint: 409B A409 A38D 92BF 15D9 6EEE 9A82 F2AC 69AC 07B9
 CACert.org Assurer