Hi,

1.
i have a cached view to an in memory source,
when i make a change in the schema (add a new field)
to the view in automatically populates the data.

is this normal? because i have 3M rows and when ever that
occur the server get stuck until the end of the population...

2.
does the in memory delete all data in the cache when it populates data ?
- (when i am not using increment)

3. is there a way to control the "in memory" db?
how many rows there are?
how much memory it uses?
if the populate went ok?
a scale of time remain to end of population?

i also consider to add a create/update option to the in memory

lets say i work with an SAP ERP and a row that exist on the
in memory had changed/update - the row as a key .
in this case i cant use the increment option and thats not optimal
that because it way better to bring only those rows that added or changed
in the last X days . and not all the 3-4 Milion records every night
that way we can even keep the reports almost "live"

thank you

itamar