At my company we are running Portfolio Server 11.0.2. Users are finding that it takes around 25 seconds to login and for the images to display (after entering login credentials). This time seems to be increasing as more images are added to the system. A simple search takes about 3 seconds. Please could anyone give me some ideas for performance tuning this issue as the users feel the system is becoming unusable.
I’m very new to Portfolio so I’d be grateful even for advice you may feel is basic.
As part of looking at this I tried running a SQL Server profiler trace and I can see that there are around a thousand events a second being processed by the SQL Server, mainly of the form “select Record_ID,Record_ID,Filename,PlaceHolder,Last_Modified,File_Size,FullyCataloged,Cataloged,Last_Updated from Item_Table where Record_ID=66081”. This seems to be irrespective of someone being logged in, so is this an underlying scanning process causing these queries? Can we stop or schedule that process?