Last post May 26, 2011 06:03 AM by GPankaj
May 25, 2011 04:42 PM|kutting|LINK
I have created a sharepoint application used lot of JQuery, Datatables and work flow. Currently the application is used by approx 50 to 60 users for the entire day. The application works but slow :(
Another ASP.NET application needs to query the sharepoint list which is been selected, updated, and used throught the day, there are approx 2000+ records in the list and the count growing day after day.
Question: I am trying to check for performance impact on sharepoint application when i use Lists.asmx GetListItems() web method? Can any let me know how GetListItems() method work internally in Sharepoint. I dont want to waste time implementing the solution
of querying list from ASP.NET application if that quering using GetListItems() to list will kill my sharepoint application.If any came accross the pros and cons.
Help greatly appreciated.
May 26, 2011 02:15 AM|adeelehsan|LINK
It should be ok using web service to fetch data from SharePoint. But you can consier using SharePoint Client Object Model in your ASP.NET application to communicate with SharePoint list data.
See the following link:
May 26, 2011 06:03 AM|GPankaj|LINK
Can you place some condition to fetch the record from the database. You can use CAML query to retrieve records from database using List.
Here is a link for CAML query
I suggest you post your question to SharePoint forum for quick and better response from sharepoint community. Here is the link
Hope this helps