hi, i need an advice. well i'm using perl to filter some large txt data.and the perl is working perfectly. so when i filter those data i import it into mysql and than use mysql to search for things connected to some other data. and now the problems start. the mysql is good for storing data but it cracks when there is a little bit demanding query to execute. so now i'm pist, because i created the whole perl infrastructure around it and that crappy program takes an eternity to run one query. for example it takes 30 min to run the same query on mssql but it takes 7 h to run it on mysql. so now i'm asking for an advice what to do. the program i'm writing should be very portable and fast. form my perspective i could do everything in perl, but i'm scared it will only extend the processing time. what to do ? all advices are more than welcome. thank you robert

In reply to advice perl and mysql by baxy77bax

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.