Database Query Slow and Doesn't Show Sometimes


We have a large database that is growing on a daily basis. Sometimes, when I run a query from the app, it doesn't show any results. I would have to go to the database, and refresh in order for the query to work again. Should I add an index to the database? What is the solution? The query is by date.
1 person has
this question
This topic is no longer open for comments or replies.