coperation progress, sql_update, views preparation