Hi we are migrating a website from a proprietary system to a new system built inSQL 2008.
We have created a lookup table that contain the UrlAlias of every individual page and its associate id. On every page request the new system has to query the lookup table with around 6,000 pieces of rows to get its id.
Now i am afraid of the load it would generate on our server and make the system slow?
Is there any work around of doing this using rewriter, regular expression etc
View Complete Post