SQL Queries cause the portal to run slowly

If SQL Queries are causing the portal to run slowly, you can fix this by rebuilding the indexes in the tables the queries are using to run. For example, if a query is touching the PWUser table, you can open up table and go to Indexes.

On each of the indexes, right-click and select Rebuild.

You will see the Index that is selected and the Total Fragmentation as a percentage on the Index.

If the Fragmentation is above 0, it can have a slowdown effect on the time it takes a query to run. Click the OK button to rebuild the Index on the table.

If you do this for all indexes the query is touching, the query should go much faster.