Folder Title Search via CSP VERY SLOW

[erinallen]

We have a custom csp page that performs the same thing the Search by Folder Title function does in CE's eportfolio.

We are experiencing poor performance with this. Sometimes it takes over a minute to come up other times it comes up in seconds. Anyone have any ideas what is going on?


Thanks
Erin

 

[synapsevampire]

Turn the TRACE facility on in SQL Server (Query Analuzer).

This will show you what's being passed to the database. If the database isn't busy with other operations, you should experience the same throughput.

-k