Hitenjain14

Results 27 issues of Hitenjain14

Currently we are running a nested query to get blacklist from DB which can be slow and will not scale as the number of record increases.

Optimization
post-mainnet

### Changes - ### Fixes - ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/gosdk/actions/workflows/system_tests.yml) to check for...

do not merge

### Changes - ### Fixes - ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/gosdk/actions/workflows/system_tests.yml) to check for...

A brief description of the changes in this PR: Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/zboxcli/actions/workflows/system_tests.yml) to check...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...

### Changes ### Fixes ### Tests Tasks to complete before merging PR: - [ ] Ensure system tests are passing. If not [Run them manually](https://github.com/0chain/blobber/actions/workflows/system_tests.yml) to check for any regressions...