Hello, I have a memory table that has 6 fields, 3 indexes and about 650,000 rows. It loads into memory fine, and works well when my application runs select quieries on it. The problem is that the table likes truncating itself. I had loaded it yesterday, ran my application, went to sleep and today morning I find it truncated. The server has not been rebooted. What can be the possible reasons why this would happen?
Couple of things to know:
I do have a dedicated server but there are other developers using the machine (so it could be a possiblity that they use up memory or something?)
The machine has enough memory to load the table
My question pretty much boils down to this:
If the machine runs out of memory, does it truncate the table?