Database Query Slow and Doesn't Show Sometimes

Hi,

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
+1
This topic is no longer open for comments or replies.