Version 5.0
After large (500-1000 records) uploads of data into Insight you may see increased save times in Inscribe.
Improvements will be noticeable if total rows in the IRENTITYCHANGES table exceeds the 200000-300000 range.
IMPORTANT: These two queries should only be used when all data has been commited and there are no Inscibe or Insight Studio data uploads in progress.
FOR DBA ONLY
Oracle:
--Backup query:
--Change date of new table
--Replace 101208 with today's date
create table IREntityChanges_101208 as (select * from IREntityChanges);
--Truncate query:
truncate table IREntityChanges;
commit;
--------------------------------------------------------------------------
MSSQL:
--Backup query:
--Change date of new table
--Replace 101208 with today's date
SELECT * INTO IREntityChanges_101208 FROM IRENTITYCHANGES;
--Truncate query:
truncate table IREntityChanges;