On Friday, June 17, 2016 at 7:54:49 PM UTC-4, Vincent Catalano wrote: > > Taking a step back a bit, have you considered something like a > materialized view at the database level for your complex queries? >
I *wish* I could use them for this use-case. Unfortunately I think that would cause more problems that it could solve. It wouldn't scale to the number of tables that would be needed (multiple ones per user; thousands of users and growing), and there would be a lot of management overhead in terms of cleanup. The Postgres datastore is also safeguarded a lot more (i.e. the machines are "more expensive" and are priority backups) while other machines that would house this on files or redis have plenty of resources to spare and are cheap to operate. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/31df3f4e-9e79-48b9-926a-bf018c237cfc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
