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. Everything else about the site is fast. 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.