In memory data access

  • Thread starter Thread starter martyn_wynne
  • Start date Start date
M

martyn_wynne

I have 3 fields, SecurityID (int), Price (decimal) and DateStamp
(DateTime), up until now i've been recording the price in a SQL table
and reading it out. The reading is fine, but the boxes are really
stuggling with the writing, the Avg. Disk Queue Length is bordering on
a bottle neck.

So, i want to have a Windows Service keep this in memory and respond to
remote calls to set and get the data. Persistance is not required.

Now, which form shall i store the info in, DataTable, a collection of
objects, xml, or some other?

I want pure speed in and out.


Thanks in advance.
 
If you want to maximize speed, use an array of objects. If that's
still not fast enough, you can use unsafe code so the array is not
garbage collected. I think that will give you the maximum possible
performance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't access memory stick 6
programming a Datalist 1
G.Skill Sniper 1866 MHz DDR3 Memory Kit 0
In memory data 2
xml serialization via a memory stream 1
SanDisk Ultra II 240 GB SSD 0
Message Queueing + Database = Memory Leak?? 2
Do I need more memory? 11

Back
Top