How To Manage Large Data in MSSQL

Posted by Kocha.Reddy under ASP.NET on 6/10/2014 | Points: 10 | Views : 1234 | Status : [Member] | Replies : 1
Dear Friends,

I am trying to develop one application which is related to voice broadcasting, here I have a huge data of DND numbers (25 Crores). At the time of broadcasting, from front end user will upload the contact numbers in xl or csv format, In this case I need to cross check the contact numbers uploaded by user are avilable in DND or not, here it is taking too much time to fetch the data.

The DND table has two columns 1. cno (nvarchar(50)) primary key 2. dt nvarchar(50),

I tried with LINQ, XML and few methods upto my knowledge, can anyone tell me, which is the best way to handle this situation.

Thanks in advance..!




Responses

Posted by: Gsm_Gsv on: 6/10/2014 [Member] Starter | Points: 25

Up
0
Down
Hi,

Have you written any batch program to load the csv file to database.
How are you managing those csv files from the application?

Please describe more on how you are cross checking the uploaded numbers with the available.


---------------------------------------
Live the life you've dreamed

Regards
MADHU

Kocha.Reddy, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response