Posted: 30 June 2009 at 5:08pm | IP Logged

Okay.  Here is my problem.  I have a site that has over 1 million records.  Right now I am set up to do http://www.xyz.com/product.cfm?prodid=123456 and want it to rewrite to http://www.xyz.com/extra_large_widget.html

But, in order to do that, I have to have two text files each with over 1 million lines.  I gradually tested this: first with 20,000 records and then with 200,000 records and experienced no problems.  I am now testing it with 2 million records and initially it looked like it was working.  Now it appears that w3wp.exe is blowing up to over 1 GB and crashing the server.  (Windows 2003 Enterprise SP2).  I found documentation from almost 3 years ago on this site, but it is no help.

Three questions:

1. Has anyone experienced this?

2. What is the limit of records this can handle?

3. If I have reached the limit, any suggestions?

Help would be greatly appreciated