CODEWITHSUNDEEP
asp.netperformanceasp.net-mvc-3routes
hivie7510
hivie7510

Reputation: 1246

Asp.NET MVC Route Performance

I have an application with a couple thousand routes.

This is because for each product we use a custom URL, as opposed to the textbook /product/id.

With this many urls, the performance is unacceptable in the router.

I am trying to find ways to improve it, but I am drawing a blank.

I have about 20 regex routes and about 3 thousand unique url routes.

Any Ideas?

Sorry for being so open ended, but I am not sure where to start.

Upvotes: 3

Views: 1300

Answers (2)

bkaid
bkaid

Reputation: 52083

I would get rid of the 3 thousand unique url routes and replace them with a generic route that is the last catch-all route. Something like:

routes.MapRoute("productRoute", "{category}/{manufacturer}/{productTitle}", new { controller = "Products", action = "Index", category = UrlParameter.Optional, manufacturer = UrlParameter.Optional, productTitle = UrlParameter.Optional });

You could also then add a custom IRouteConstraint to validate that the category exists (but just make sure it doesn't hit your database every time or performance will degrade).

Upvotes: 0

Tomas Aschan
Tomas Aschan

Reputation: 60664

If your urls are all on the format yoursite.com/{url}, you can still store all the three thousand urls in the database, and create a custom controller factory which uses the {url} parameter to look the correct information up in the database and assign correct controller, action and any parameters you're using.

There are lots of posts on google on how to implement the controller factory.

I imagine you'll also want some parsing of the existing routes to put them all in the database - this can probably be done by iterating over the RouteTable after you instantiate your application (i.e. after RegisterRoutes() is called).

Upvotes: 3

Related Questions