cameri / nostream

A Nostr Relay written in TypeScript
MIT License
715 stars 185 forks source link

[BUG] Query is too large to execute(and takes too long time to return data) #309

Open ikuradon opened 1 year ago

ikuradon commented 1 year ago

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. Run docker compose with DEBUG=knex:query
  2. See log

Expected behavior A clear and concise description of what you expected to happen. light query with a small amount of arguments.

Screenshots If applicable, add screenshots to help explain your problem. image image image

System (please complete the following information):

Logs If applicable, attach log messages showing the bug and context when the bug happened. It's too long to post here, I created gist. https://gist.github.com/ikuradon/0db31b3133ab926465fdfa214ca60620

Additional context Add any other context about the problem here.

cameri commented 1 year ago

Thanks @ikuradon for reporting the issue. This will be addressed when tags are saved on their own table.