Low process speed Large scale storage question...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lior3790
    New Member
    • Oct 2006
    • 9

    Low process speed Large scale storage question...

    Hi,

    I'm implementing mass information procedures that is stored in a SQL Database.
    What methods and actions i need to take in order for the process to be faster in a case like this (its more then 1000000 rows).

    I'm trying also to improve the memory usage since i use the DataTable in C# and I'm looking for a better way to process the retrieved data. is there a better class or method thats improving the speed and preventing any memory leaks ?

    please advise....

    Thanks for any help,

    Lior S ;)
Working...