[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-devel
Subject:    Re: [Gambas-devel] Support for postgresql materialized view
From:       <gambas () users ! sourceforge ! net>
Date:       2015-04-08 10:33:36
Message-ID: 55250400.8050303 () users ! sourceforge ! net
[Download RAW message or body]

Le 08/04/2015 12:15, gambas a écrit :
>
> Hi benoît , I use that simple patch in all my project using materialized
> view from almost 6 month , I think it's working well.
>
> For the question of difference between standard view and materialized one:
> A view is a virtual table created everytime you read it , created with a
> query.
> A materialized view is a table created by a query that can be updated
> every time.
> The main difference is that when a materialized view is created it's
> stored at creation time or when you update it , and there's no need to
> be calculated every time you read it.
>
> bye,
> marco.
>

Commited in revision #7024.

Regards,

-- 
Benoît Minisini

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Gambas-devel mailing list
Gambas-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-devel
[prev in list] [next in list] [prev in thread] [next in thread]