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