I'm not sure using a denormalized table and NH and a huge table is right for reporting... Did you check some reporting tool instead?
Gustavo. On Sun, Apr 5, 2009 at 9:08 PM, Dotan N. <[email protected]> wrote: > So in the case of a denormalized table that is huge, there is no > alternative (design-wise) but to wait ? > > > On Sun, Apr 5, 2009 at 8:06 PM, Carsten Hess <[email protected]>wrote: > >> >> If youre happy with the execution plan and just want NHibernate to >> accept the long running query, you can increase the command timeout >> ("command_timeout") in NHibernate. >> >> Regards >> Carsten Hess >> >> On Apr 5, 10:14 am, Gustavo Ringel <[email protected]> wrote: >> > Maybe you can denormalize and perform some calculations before writing >> to >> > the archive tables so you have a report oriented model and minimize >> joins, >> > etc... >> > >> > I do writes to the report database asynchronously so i have the time to >> > prepare the data for reporting and avoid doing calculations and joins >> when >> > reporting... >> > >> > When i started with this i thought i was crazy but then i have read >> here: >> > >> > http://martinfowler.com/bliki/ReportingDatabase.html >> > >> > and something from Greg Young that i cannot find now with the same ideas >> i >> > used. >> > >> > I did something much more simpler for sure but the idea can be taken >> from >> > there... >> > >> > Gustavo. >> > >> > >> > >> > On Sun, Apr 5, 2009 at 11:03 AM, Dotan N. <[email protected]> wrote: >> > > hey all, >> > > whats the current solution for having archive tables and sometimes >> > > performing queries on them, right now i'm getting timeouts like crazy >> (im >> > > talking > 1M records, and not cutting edge servers). i have indexes >> > > whereever possible and the most taxing goes on index seeks (i looked >> at >> > > execution plan) >> > >> > > any ideas? >> > >> > > thanks. >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
