where to store report info

William Attwood wattwood at gmail.com
Tue Dec 9 16:54:29 MST 2008


Kyle--
   You could upgrade the hardware and/or enhance the storage of the data
through normalization, and RDBMS specific methods such as indexes.

   It is acceptable to store a completed report in another table.  If the
report doesn't need live data in the moment, storage of the report is
acceptable to keep the load off of the other table(s) and DB.

   A third solution, depending on your infrastructure, is to run the reports
against a slave database; if it's only reads.  This way the load doesn't
impact your master DB.  You run the risk of being a few records behind
"Life", which is probably an acceptable risk.

 Good Luck!
--Will

On Tue, Dec 9, 2008 at 4:50 PM, Kyle Waters <unum at unum5.org> wrote:

> I almost sent this to udbug but felt it was more of a general question.
> I have a database with lots of information in it, and find that I need to
> run a report the is going to take up to several minutes to run.  It's ok if
> I only run this report once a day in the morning before everyone comes in.
>  Now the question that perplexes me is how should I store this report.  I
> think it would be good for it to be viewable as a web page by many people in
> the company, but one user will need to be able to download it as a csv file.
>
> So part of me wants to treat this like a materialized view.  Though I don't
> want to do it all in pg/sql.  Is that an acceptable solution?  Grab
> information out of the database, process it and then stick it back into a
> table.  Is there a better more acceptable way of doing this?
>
> Kyle
>
> /*
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
> */
>



More information about the PLUG mailing list