Hi,
We are using **Redis (Redis Version Compliance 5.0.4) **and redisearch-enterprise (Ver 1.4.6) Capacity: 1000000 docs (according to the redislabs dashboard), and for testing I have also installed Redis 5.0.4 and Redisearch 1.4.6 locally from github, however the versions either don’t seem to match, or there is something with my local configuration. How do I make sure I am using the same version for testing and production?
Here is an example:
In our cloud account:
-
Performance is very poor with FT.AGGREGATE - I posted about this in a separate post.
-
Notice how the SORTBY returns the TripID just fine without any APPLY statements
-
There is no count returned by the enterprise version - it always says 1, whereas on my local machine, the correct count is returned.
“FT.AGGREGATE” “trips_hash_index” “(@VisibleToCompanyIDs:{2}) (@TripMainTypeID:{6|4|1|3|2}) (@TripStatusID:{1|5|4|6|3})” “SORTBY” “2” “@TripID” “DESC” “LIMIT” “0” “10”
-
(integer) 1
-
- “TripID”
-
“620204”
-
- “TripID”
-
“620203”
-
- “TripID”
-
“620202”
-
- “TripID”
-
“620201”
-
- “TripID”
-
“620200”
-
- “TripID”
-
“620199”
-
- “TripID”
-
“620198”
-
- “TripID”
-
“620197”
-
- “TripID”
-
“620196”
-
- “TripID”
-
“620195”
(0.92s)
``
In my dev environment, I need to use APPLY to retrieve the IDs, otherwise, this is the result returned:
“FT.AGGREGATE” “trips_hash_index” “(@VisibleToCompanyIDs:{2}) (@TripMainTypeID:{6|4|1|3|2}) (@TripStatusID:{1|5|4|6|3})” “SORTBY” “2” “@TripID” “DESC” “LIMIT” “0” “10”
-
(integer) 289901
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
-
(empty list or set)
``
In dev, with APPLY:
“FT.AGGREGATE” “trips_hash_index” “(@VisibleToCompanyIDs:{2}) (@TripMainTypeID:{6|4|1|3|2}) (@TripStatusID:{1|5|4|6|3})” APPLY @TripID AS TripID “SORTBY” “2” “@TripID” “DESC” “LIMIT” “0” “10”
-
(integer) 289901
-
- “TripID”
-
“362285”
-
- “TripID”
-
“362284”
-
- “TripID”
-
“362282”
-
- “TripID”
-
“362280”
-
- “TripID”
-
“362279”
-
- “TripID”
-
“362270”
-
- “TripID”
-
“362269”
-
- “TripID”
-
“362268”
-
- “TripID”
-
“362258”
-
- “TripID”
-
“362257”
``
Thank you