Hi Arnaud,
You can pause indexes during the SQL import with:
Begin SQL
ALTER DATABASE DISABLE INDEXES;
ALTER DATABASE DISABLE CONSTRAINTS;
End SQL
and then after the import completes, restore indexes with:
Begin SQL
ALTER DATABASE ENABLE INDEXES;
ALTER DATABASE ENABLE CONSTRAINTS;
End SQL
Details at:
http://doc.4d.com/4Dv16R4/4D/16-R4/ALTER-DATABASE.300-3451136.en.html
- Jeremy French
> On Oct 23, 2017, at 6:45 AM, Arnaud de Montard via 4D_Tech
> <[email protected]> wrote:
>
> PAUSE INDEXES does not exist too, I suppose it may result in a faster import.
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
