mORMot Open Source

cypriotcalm

Member

Registered: 2015-02-18

Posts: 122

index creation in the mORMot

Hi ab,

I have also several questions about the index creation.

1. How can I enable or disable the automatic index creation? I mean the indexes which look like INDEX7CB68FFE350C6FF1(...)
2. How can I check through the ORM whether an index already exists?
3. How can I create my own indexes through the ORM?

Thank you for your answers!

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: index creation in the mORMot

Did you check the doc?

1. TSQLInitializeTableOptions
2. Index existence is checked at creation
3. TSQLRestServer.CreateSQLIndex or TSQLRestServer.CreateSQLMultiIndex

cypriotcalm

Member

Registered: 2015-02-18

Posts: 122

Re: index creation in the mORMot

Yes, I did check the doc ;-) But anyway thx for your help!

cypriotcalm

Member

Registered: 2015-02-18

Posts: 122

Re: index creation in the mORMot

I want to disable the auto creation of the indexes.

This code works!

  CreateModel
  VirtualTableExternalRegister

  fSQLRestServerDB.CreateMissingTables(0, [itoNoIndex4TID]);

But in this case the auto indexes are created:

  CreateModel
  VirtualTableExternalRegister
  
  fMySQLModel.Table[TMySQLTable.SQLTableName].InitializeTable(fSQLRestServerDB, 'SomeTIDFiled', [itoNoIndex4TID]);

  CreateMissingTables

Is there some issue?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: index creation in the mORMot

You should not call the InitializeTable() directly as such.

InitializeTable() is called by CreateMissingTables.