Is there a generic way using DBI to limit the number of rows returned by a query regardless of the DB you are connecting to? I am debugging a program that is fairly long and has several places where large RS are returned. I really don't feel like adding LIMIT syntax to each query(especially because in some places the SQL is dynamic), I'd rather just be able to do something to the excute where it just gives me back say 100 rows rather than the whole thing. My other problem is that this particular script connects to various DB types so the syntax for the SQL is different even if I chose to add a LIMIT clause to each query.
Thanks
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|