On Friday, February 8, 2013 8:37:29 PM UTC+1, junepeach wrote:
> By the way, when we should use view, and when to use temporary table? > temp tables are static, you manually populate them with data and process it as with any other table. views are populated every time you query them. there are many use cases, but to put it very simply: temp tables are (short-term) data storage, views are data access. I don't know what's your use case, but I'll risk to oversimplify it for a moment: if you need just convenience (to query a preprocessed/simplified set/subset of data) - use views, if you need a set/subset of data to be persistent across many queries in the same session - use temp tables. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" 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]. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
