PC Review


Reply
Thread Tools Rate Thread

In memory data access

 
 
martyn_wynne@hotmail.com
Guest
Posts: n/a
 
      24th Feb 2005
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.

 
Reply With Quote
 
 
 
 
Pat A
Guest
Posts: n/a
 
      25th Feb 2005
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.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access cant change the data type ; there is not enough disk space or memory. barret bondon Microsoft Access 4 23rd Feb 2011 09:42 PM
Performance issue while copying data from video memory to system memory Manish Windows XP Drivers 0 13th Aug 2008 01:03 PM
transfer my data from a memory stick(excel) to microsoft access? =?Utf-8?B?d2FpbndyaWdodHRob21hcw==?= Microsoft Access External Data 1 17th Sep 2006 04:56 PM
creating a Memory Resident Program (TSR) to connect to Access Data =?Utf-8?B?QXZpcg==?= Microsoft Access 2 2nd Sep 2005 10:28 AM
Memory problem getting data from Access into Excel Erik Wel Microsoft Excel Programming 0 20th Jan 2005 12:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:24 AM.