it'll take wayy long to load.

There are a couple of tricks you can use to start displaying tabular data before the entire table is generated (which can, as you note, take a long time). The big trick is to break the big table up into multiple smaller ones. (You'll have to but them right up against each other to avoid blank lines between them.) The browser will display each table as soon as it can, which will be soon unless you're wrapping things into an even bigger table. To make this trick work, you'll need to specify widths for each cell. This means streaming more data to the browser, but that's the trade-off you have to accept for getting a quicker initial display.

Give it a try, and see if you quick quicker seeming results. If it works, consider sticking with whichever approach yields the more maintainable code. To my eye, it's the fetchall_arrayref.

In reply to Re: bind_columns OR fetchall_arrayref by dws
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.