On 2012-06-10 17:44, Peter Morris wrote:
Twitter blog claims a record of 6,939 tweets in 1 second - this was 4
seconds after midnight in Japan on New Year’s Day.
I decided to run a test, the steps to insert a row would be 3 selects
+ 1 insert (because of the data structure involved) - I managed 6900
in 578 seconds.
Obviously I am not expecting Twitter-like load handling on my
development laptop, but what tricks are involved in getting this kind
of performance and would NH + SQL Server be a bad choice for
implementing a similar service?
Start with "the data structure involved". There is no reason at all to
do 3 selects to accept 140 bytes of data.
There are plenty of "war-stories" from the various big services
available, as an example I found this (Bad) video of youtube's early days:
http://blip.tv/file/1069718/
Best Regards, David
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
