Can SqlServer in-memory tables be replacement with ASP.NET cache?

Question

Our current system was architectured like;

We have around 5 million records in a DB table. Depending on the need, we get, say a resultset of 1 million records and keep them in cache throughout the application, when we are done, get rid of them.

Now, instead of using .NET application's memory, "Is it possible to use in-memory tables to keep those 1 million records in an in-memory table whilst disk based table still keeps 5 million records?"

usr · Accepted Answer · 2016-07-29 09:58:56Z

1

That's possible. Performance will still be less than with in-process data. One of the most expensive things to do when executing a cheap SQL statement is all the overhead of executing anything at all (network, serialization, ...).

You will need to measure (or have a good understanding of) whether the now reduced performance is still enough.

If the existing system works without problems there is no need to change anything.

answered Jul 29, 2016 at 9:58

usr

172k38 gold badges251 silver badges380 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jude Over a year ago

Are we supposed to handle that, each time like "Select into...". Any built-in mechanism to accomplish this, just to automate it?

usr Over a year ago

Nothing automated there. Also, you will find that Hekaton requires more labor to implement than other tables do. If you want to save work this option is not that attractive. If you elaborate more on your performance targets and the queries you run I might be able to recommend something

Mani Gandham · Accepted Answer · 2016-09-04 06:45:14Z

0

SQL Server already has advanced caching algorithms built-in. How big is your table? 5 million rows are not that big these days, the entire table might be already cached into memory and you can just use SELECT queries by primary key.

answered Sep 4, 2016 at 6:45

Mani Gandham

8,4132 gold badges54 silver badges60 bronze badges

Collectives™ on Stack Overflow

Can SqlServer in-memory tables be replacement with ASP.NET cache?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related