Search is slow

[fakeologist]

Anyone else notice search is very slow? Maybe it's just my instance.

[JoshWho]

No, it really is slow. Depends how large the database is also but it is slow. Would be nice to see it be a little more instant than the long hang it has most the time.

[JoshWho]

Somehow there needs to be a cache system for the search so the queries won't hang.

[walt93]

Search has been that way for a while.

I assume switching to Postgres would be like open heart surgery or are we sitting on some ORM layer that can do so with relatively less pain? I've used it to query 250k-500k records building a video page similar to avideo and it was blazing fast. Or is mysql not the barrier here?

[JoshWho]

I questioned the SQL too, but I am sure that can't be the issue, I think there is a missing element here for cached queries or something.

[elico]

@JoshWho The question is: What and how the search query do? It's possible that the issue is not the MySQL but rather a coding issue.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.