Hello freinds

I am working on the perl API project and in the back end of it I am using MySQL. I have written a perl API script to extract data from database. I am using DBIX module to do so !!!

The General form of the query which I am using is as follows - 

 my $tr_id_rs =
        $schema->resultset("TestRunStatus")->search(
            {
             "DATE(test_run_id.start_date)" => { ">=" => $start_date,
                                                "<=" => $end_date,
                                                },
             "test_run_status_type_id.name" => $status_type,
             },
            { select    => "test_run_id.id",
              join      => ["test_run_id",
                            "test_run_status_type_id"],
              group_by  => "test_run_id.id",
              order_by  => "test_run_id.id",}
        );

[download]

I am extracting a database ID for the matching i/p conditions. Then depending on user's input I extract the information related to that database ID. I found that if I have to extract larger data sets then it's time also gets increased a lot. I wants to minimize the time of execution.

Can any body tell me how to achieve that ? Is there any other way extracting data from the MySQL DB ?

In reply to minimizing executaion time in database operations with DBIX by siddheshsawant

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.