mORMot Open Source

dbjulio

Member

From: Brasil

Registered: 2014-05-19

Posts: 2

Join with selected tables

Hi...

first of all, sorry for my english... I'm brazilian

we have a project with mormot, and we are impressed with the performance, congratulations

I have a question about the function CreateAndFillPrepareMany...

we have a class with three tables, they are linked using Pivot, TSQLRecordMany, etc., but I want to open only two tables using this function... how can I do this?

thanks.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Join with selected tables

CreateAndFillPrepareMany() works only for 2 tables.
If you have three tables, you need to use your own SQL statement.

BTW, why did not you consider using sharding, and a document-oriented aggregate layout, using variant properties?
See the SAD 1.18 pdf about "many to many" relationship and data sharding.

dbjulio

Member

From: Brasil

Registered: 2014-05-19

Posts: 2

Re: Join with selected tables

we did not know that CreateAndFillPrepareMany only works with two tables.

I'll read about this in the SAD 1.18 and adapt my code.

thanks for the reply.