1
OD/WEK & JAVA API / Re: ODWek REST - Search with SQL - Segment start and stop date
« Last post by rjrussel on March 10, 2023, 09:09:20 AM »CMOD will handle the rest for you.
Thats fine, I just dont get how this work.
I have a segment date field, when I use startdate = 2023-02-25 I still get hits where I have records contains date = 2021-08-04
Searching without SQL seems to be extremely slow compared to Search with SQL.
Did a few test request now.Total number of hits = 1
- Search with SQL = 59ms
- Search without SQL = 1677ms. Even up to 3s
If you know how we can use segment startdate and stopdate in Search with SQL - I'd very much like to know
The short answer is CMOD uses the segment startdate and stopdate to limit what tables it searches across. If an AG has 100 tables in it, using a segment field can help significantly. If you only have one table for a given application group this will not of course help much.
So, searching a folder with a date field that is also defined as a segment field will cause cmod to first identify what data tables fall in the given range and then performs a search only against those tables.