Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

How to access to a big amount of data?

Asked By: David Row Date: Nov 15, 2010 Category: Sharepoint Views: 483

?Hi,

I am solving problem now. I have big amount of data (around 10000 rows) at SQLserver. I wanna find the best way how I could get those data, use and store them because after that I won't work with all of them. I will make query which retrieve only few rows which I will display at WebPart and those rows can be stored somewhere (cash) because data is changed only once per day.

I am using SharePoint server 2007 and Visual Studio 2008 SP1.

I am really wondering which classes and functions I shoud use for it.

Thanks a lot!

Tagged:how to access big amount of data

1 Answer Found

Answer #1 Answered By: Sirisha Reddimasi Answered On: Mar 02, 2011

Hi,
I am not very clear on your requirement. But if you want to use the data fetched from SQL only to filter content and display in web part then one way is you can use that filter condition in SQL Query itself and get the filtered data and store it in an list and display in web part. Once you get new data on next day then clear the list by writing an custom exe in Visual Studio.

If not 2nd way is get all the SQL data in to an list by creating a custom exe in Visual Studio and then filter it use it and next day run an custom exe to clear the list and then get data.

Didn't find what you were looking for? Find more on How to access to a big amount of data? Or get search suggestion and latest updates.