Admin > Open-Url-Rewriter tab hangs

Dec 10, 2013 at 3:20 AM
Edited Dec 10, 2013 at 3:21 AM
Our site has a large number of portals. The open-url-rewriter tab in portal 0 hangs for many minutes and doesn't load. We have 56k tabs across our DNN installation, and 125,600 rows in the OpenUrlRewriter_UrlRule (so far) and I'm not sure it's done recording. Any thoughts on getting the page to load?

DNN 7.2 and O.U.R. 1.1.1
Coordinator
Dec 10, 2013 at 8:42 AM
Hi,

Interesting case. I don't have the chance to test yet with so much records.

On page load it's some statistics about the url rules are loaded.

It can be 2 things :

1) slow db query
or
2) slow access to the url rules in cache.

Maybe you can check if it is a slow db query ?
Is it on a production web site ?

Is it only slow on portal 0 ? Not on other portals ?

if you send me a host access at sachatrauwaen [at] yahoo dot com, i can have a look.

Regards,
Sacha
Dec 10, 2013 at 5:51 PM
The db query (edit records) takes about 18 seconds to display the records on the server (directly on SQL Server).

The site is our primary company site (live sales and employee use) so I emailed the data to test on your end.

The URL Rewriter tab doesn't load on any portal.

Thanks for the assistance
Coordinator
Dec 10, 2013 at 11:05 PM
Hi,
i just posted a new beta version 1.1.2.

It contains a new index for better performance when a large number of portals.

And also change the admin module : portals stats are not more loaded automatically on page load.

Tell me if it resolve your problems ?

Regards,
Sacha
Marked as answer by sachatrauwaen on 12/10/2013 at 11:46 PM
Dec 11, 2013 at 1:47 AM
perfect. It opens in 5-6 seconds now. Thank you very much. Let me know if I can help in any other way.