SQL and DBI are meant to provide an easy to use interface that saves you coding time. Most database applications require far more time to write by hand than is taken up by all the queries conducted over a year plus. The big question is, do you need that extra speed here? Is maintaining and updating 3000 files worth the extra coding time? In this case, probably yes, since you're already doing the primary database work and just want efficient searching of data. You could, however, put all the data in one file, with a secondary file showing start and end locations for each question set. This would leave you most of your speed without requiring thousands of individual files.
-
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.
|