I have sharepoint application which takes more time to load. So i planned to move data from certain list to another table in same database. Since alluserdata table in sharepoint stores data from all lists and we use procedure to get data from sharepoint database. Is my decision to move data from alluserdata table is right or not? Is there any other solution to make the application load fast?

  • No, not right, not right at all. In fact it's the very antithesis of right. You need to employ someone with SharePoint experience to help out I suspect. SharePoint can run quickly when configured correctly and without recourse to meddling with the internal data structure. – Paul Leigh Aug 22 '13 at 8:01
  • Actually i choose this method because when i try to load my sharepoint page i am getting error page. When i look into that error in log file, i can find that is because of SQL query timeout error. – Suren Aug 22 '13 at 8:08
  • Your configuration (or customisation) of SharePoint is at fault then. Trying to redesign the way in which SharePoint works will not help you here. – Paul Leigh Aug 22 '13 at 8:25
  • The same instance works fine for one year. Now only we are facing this issue. – Suren Aug 22 '13 at 9:35
  • regardless @suren, manipulating and even reading data inside sharepoint databases through SQL is not only bad practice, but it flags your environment as unsupported. I would further diagnose why your application loads slower than satisfactory. Maybe you can specify what the application is doing. – Mike Jan 14 '14 at 18:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.