It is hard to answer this question until you define
it'll take wayy long to load

and

Or any other faster method?

as well as some benchmark which will help you decide you have achieved the speed you desire.

You db is so simple it could well be just a text file. On any reasonably modern computer Perl will pump it out faster than any internet connection would be able to handle. Hence, your bottleneck (for loading 4k records, if I understand your problem correctly) will be the client computer rather than the server. Your other worry would be running out of browser memory on your client computer before everything gets loaded. You are asking to load a 40000 element array along with the html fluff. Make sure your users have enough memory on their computers (which, again, should not be a problem).

In other words, first define the yardstick you want to measure against before worrying about which method to measure. Because unless you recognize your destination, you will not know you have arrived.

If you just want to compare bind_columns or fetch_*, a simple use Benchmark will solve that problem for you before any of us conjecturing will be able to.

Good luck.

In reply to Re: bind_columns OR fetchall_arrayref by punkish
in thread bind_columns OR fetchall_arrayref by tanger

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.