Fastest?
-
which database should I use in order to achieve the highest speed possible while reading and writing? I need to write to database once, but read the database quite often I write about a million strings.
TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html
-
which database should I use in order to achieve the highest speed possible while reading and writing? I need to write to database once, but read the database quite often I write about a million strings.
TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html
You could: use sql server and also use sqlcachedependency and dump the table to NT memory. that way you are caching the records in NT memory and it will pole sql server looking for changes. if a change is found, it replaces the cache and again the NT memory is in sink with the database.
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous 'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous