Monday, February 13, 2012

40000 Pages /day with SQL Express

I can some on tell why I can or I cannot run a 40000 Pages /day with SQL Express.

Thanks

Easily|||

The reponse is not.

I did the test and the performance limitation from msde makes it impossible to run properly

Erez

|||

You asked about SQL Express, not MSDE. But even MSDE should be able to handle 40,000 pages/day easily, so I would take a look at what you are doing wrong that's causing the performance issue.

With an average response time of serving a page of 2 seconds or less, you could serve 40,000 pages in a day. If you can't get your average page response to be below 2 seconds, you've got other problems, cause that's painfully slow. That's with a single page request being presented in a serial fashion, which isn't likely. With overlapping requests even with a 2 second response you should be able to handle a LOT more than 40,000 pages under most circumstances (Depends where the 2 second response bottleneck is).

Now that's assuming a consistant load for 24 hours, perhaps you wanted to know some other metric? Like can I handle a peak load of x pages/sec, or some such.

No comments:

Post a Comment