Sharepoint 2007 - new service request running very slow. RRS feed

  • Question

  • On Sharepoint server 2007, we have a service request site with 9000 records in it.

    Clicking a new request can take 25 seconds before the blank form opens which seems very slow to say the least.

    Looking at the alluserdata table in sql server shows that the table contains lists from another site. In all there are 115000 records in this table.

    If I do a select * from alluserdata, it takes 30 seconds to run. There are over 100 fields with no data in them. This, looking at raw data, is really bad.

    Is there anything we can do to speed things up?

    Many thanks for any help.

    Wednesday, January 16, 2013 3:19 PM