Hey all,
My database reached 2 gigs fo memory. So I clicked compact and repair which shrunk it down to 200 mb. But now when I run query, it only returns 5 records, for example, when it should at least be returning 50. It was pretty close to accurate and now it is completely inaccurate. The queries didn't change. And I reimported my list of records after deleting the old list. But the inaccuracy still persists.