redis command takes long time to fetch data

Asked Nov 12 '19 at 07:19

Active Nov 12 '19 at 12:05

Viewed 882 times

I have created a bat file for deleting custom data from Redis DB. I have following code

@echo off & cls
title :Redis Service
echo "Redis cache clearing started"
for /F "tokens=*" %%f IN ('redis-cli -h 192.134.56.67 -p 6379 -a MyPassword keys "My.Key.*"') do (
 echo "%%~f"
 redis-cli -h 192.134.56.67 -p 6379 -a MyPassword del "%%~f"
)
echo deletion completed

But it takes a long time to execute. How to use SCAN instead of KEY command in above code

edited Nov 12 '19 at 12:05

asked Nov 12 '19 at 07:19

Abdul Manaf

4,933
8
51
95

ok.. let me first get this. when running `redis-cli -h 192.134.56.67 -p 6379 -a MyPassword keys "My.Key.*` on its own, does it return a list of strings? – Gerhard Nov 12 '19 at 07:31
No. it remains stuck – Abdul Manaf Nov 12 '19 at 12:43
Ok so then the issue is not with the script.. – Gerhard Nov 12 '19 at 12:46
ok. But below command returns data – Abdul Manaf Nov 12 '19 at 12:49
for /F "tokens=*" %%f IN ('redis-cli -h 192.134.56.67 -p 6379 -a MyPassword keys SCAN 0 MATCH "My.Key.*" COUNT 1000 ') do ( echo "%%~f" ) – Abdul Manaf Nov 12 '19 at 12:50
yes. because you are setting a limit of 1000 – Gerhard Nov 12 '19 at 12:58
2

the `KEYS` command is slow if the key space is getting huge. it is not recommended to use `KEYS` command as will block the whole redis server. the recommend practice is to use the `SCAN` command and keep scanning until 0 returned. – Tuan Anh Tran Nov 13 '19 at 07:31

redis command takes long time to fetch data

0 Answers0