Hi Everyone,
I am assuming InMemory tables are faster than TempDB tables. It can hold only less data and fetching is much faster as this is just like human memory.
Recently I read TempDB is fater than Inmemory tables. Following is the link. Is that really true.
The answer is: “it depends”. If you have just a few kilobytes of data, InMemory tables holds them in RAM, which is extremely fast. But if you have more data, it gets written on disk, not to waste RAM. Disks are much slower than RAM, of course. But you still can have data directly on client or AOS, without having to go to database.
But TempDB can use the whole power of SQL Server, which may make a big difference if you’re running queries on large sets of temporary data.
Good Reply.