mORMot Open Source

ComingNine

Member

Registered: 2010-07-29

Posts: 294

Test or use case for TRestClient.RTreeMatch ?

Page 174 in the SAD doc v1.18 describes TRestClient.RTreeMatch. However, could you create test case or use case about it ?

In SynSelfTests.pas, there is a test of TSQLRecordRTree, which only involves RTree index, but not TRestClient.RTreeMatch, which involves both data and RTree index. 

For example, it is not clear why the TSQLRecordMapData has a BlobField containing the textual representation of the coordinates exposed by TSQLRecordMapBox. Are these two types explicitly defined ? Or TSQLRecordMapData somehow includes a TSQLRecordMapBox. Many Thanks!...

Last edited by ComingNine (2014-05-04 21:56:05)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: Test or use case for TRestClient.RTreeMatch ?

As explained by http://www.sqlite.org/rtree.html - our classes are just wrappers over it - the real data is in fact not stored within the RTREE table.
The RTREE table contains some kind of "index" to speed up the request, but the actual data should be stored, e.g. as a BLOB, in the main table.

Key Point: An R*Tree index does not normally provide the exact answer but merely reduces the set of potential answers from millions to dozens.

ComingNine

Member

Registered: 2010-07-29

Posts: 294

Re: Test or use case for TRestClient.RTreeMatch ?

Thank you very much for your helpful comments !