Stack Overflow
Stack Overflow

Questions tagged [in-memory-tables]

36 questions
16
votes
7 answers

Out of Process in memory database table that supports queries for high speed caching

I have a SQL table that is accessed continually but changes very rarely. The Table is partitioned by UserID and each user has many records in the table. I want to save database resources and move this table closer to the application in some kind of…
SetiSeeker
  • 6,482
  • 9
  • 42
  • 64
12
votes
1 answer

Run SQL query on MySQL service startup

I have created HEAP (ram) table on mysql for faster query. But after mysql server restarted, the data in my Heap tables is not loaded. My normal table name: products with id, product_name, status as myisam id => integer and auto_increment, primary…
EngineerCoder
  • 1,445
  • 15
  • 30
6
votes
1 answer

100% in-memory HSQL database

I have a Java application set up as a service to do data-mining against ~3GB of data every few hours. I would like this to occur 100% in memory. Ideally I want the application to be isolated from everything; I want it to construct the database, do…
Alex Beardsley
  • 20,988
  • 15
  • 52
  • 67
5
votes
1 answer

Using Web API TransactionScope and SQL Server in-memory table Issue

Whenever I am accessing a stored procedure which has an in-memory table through the Web API TransactionScope I am getting this error: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back…
Askarc Ali
  • 318
  • 4
  • 21
4
votes
1 answer

Issue with memory optimized tables transaction commit dependencies

I'm working with SQL Server 2016, and working on large group of sprocs that are all called by one parent sproc. All the sprocs do nothing but reads to return one result set. I've confirmed all necessary objects are in cache and no physical reads are…
mituw16
  • 5,126
  • 3
  • 23
  • 48
4
votes
3 answers

How to Find Whether SQL Server 2016 Db is set to be Memory Optimized or not?

I want to get information through SQL query for any database in SQL Server 2016 whether it is already set to be memory optimized or not. I know following query SELECT DatabasePropertyEx('DATABASENAME', 'IsXTPSupported'); tells you that whether you…
Abdul Qayyum
  • 51
  • 3
3
votes
0 answers

creating SQL memory table visual studio

I'm trying to setup an SQL database project (using Visual Studio 2017). I want this to create a dacpac that could be run on either SQL Server or Azure SQL, would create a database from scratch with a single publishing. However, I'm running into…
Stenso
  • 31
  • 1
3
votes
0 answers

Write-Write Conflict in In-Memory OLTP SQL Server 2016

We have used the In Memory OLTP feature for our DB. When we are running transactions , we are encountering the below issue. SqlException: The current transaction attempted to update a record that has been updated since this transaction started. The…
Gurmeet
  • 3,094
  • 4
  • 19
  • 43
3
votes
2 answers

Rails 5 Active Record - is it possible to keep a table in memory?

If we have a small table which contains relatively static data, is it possible to have Active Record load this in on startup of the app and never have to hit the database for this data? Note, that ideally I would like this data to be join-able from…
asibs
  • 243
  • 6
  • 14
2
votes
1 answer

How to change Delphi FireDAC tFDMemTable field name in design-time

I try to change the field name of FDMemTable1field1 which is 'field1' to 'field3'. There is no code and all is done in design-time. TForm1 = class(TForm) DBGrid1: TDBGrid; DataSource1: TDataSource; FDMemTable1: TFDMemTable; …
SHIN JaeGuk
  • 494
  • 1
  • 5
  • 14
2
votes
1 answer

SQL Server In-Memory table use case with huge data

I have SQL Server table with 160+ million records having continuous CRUD operations from UI, batch jobs etc. basically from multiple sources Currently I have partitioned the table on a column to have better performance on the table. I came across…
VR1256
  • 1,266
  • 4
  • 28
  • 56
1
vote
1 answer

Oracle: detect a NOT INMEMORY column

I have a table that has been created with a NOT INMEMORY column: CREATE TABLE myTable ( foo VARCHAR2(20 BYTE) NOT NULL, bar VARCHAR2(20 BYTE) NOT NULL, baz VARCHAR2(2000 BYTE) NOT NULL, ); ALTER TABLE myTable INMEMORY; ALTER TABLE myTable NO…
Julia Hayward
  • 1,987
  • 1
  • 14
  • 16
1
vote
1 answer

SQL Server - Memory quota error during migration to in-memory table

We are currently migrating to in-memory tables on SQL Server 2019 Standard Edition. The disk based table is 55GB data + 54Gb of indexes (71M records). RAM is 900 GB. But during data migration (INSERT statement) we get an error message: Msg 41823,…
duhast
  • 13
  • 3
1
vote
1 answer

DML triggers in memory optimized table in SQL Server 2016

I have two tables: table 1 is disk based storage and table 2 is in memory storage. I create a DML trigger on table 2 and in that trigger, I insert a record into table 1. Will it be possible?
Balamurugan.Santhanaraj
  • 156
  • 1
  • 2
  • 8
1
vote
3 answers

Best Table Engine for massively updated MySQL table. MyISAM or HEAP?

I am creating an application which will store a (semi) real-time feed of a few different scales around a certain location. The weights of each scale will be put in a table with only as many rows as scales. The scale app feeds the MySQL database a…
muncherelli
  • 2,887
  • 8
  • 39
  • 54
1
2 3