Generate JSON - how to improve performance

views:

answers:

Generate JSON - how to improve performance

Here is what I am doing currently.

Get data from database in DataTable (max records would be 100 but stored proc will search against more than 500,000 records. I already took care of search optimization in database. I am looking how I can improve the performance as much as I can in step# 2 and step# 3 below.)
Create a generic list (List)
Use that list and passing it to JavaScriptSerializer to get JSON back.

There are couple more options to generate JSON like DataContractJsonSerializer or JSON.NET or WCF. I wanted to know which options give better performance? Or any other way I can improve the performance?

+1 A:

Here are some perf results from the author of JSON.Net: http://james.newtonking.com/archive/2010/01/01/net-serialization-performance-comparison.aspx. The conclusion would be JSON.Net, if you care to use a third party library.

Frank Schwieterman 2010-07-13 22:07:24

Thanks Frank. One thing I don't understand where that deserialization comes in picture. I am just using JavaScriptSerializer class to serialize objects.

shailesh 2010-07-14 16:16:24

Well the perf results cover serialization and deserialization. If you only care about serialization it should be sufficient. That would imply some other component is doing deserialization, I couldn't tell you where that is without knowing more about the application you're working on.

Frank Schwieterman 2010-07-14 16:34:21

I'd also agree with some of the other comments that this probably isn't your performance bottleneck... But JSON.Net is a good library to use either way.

Frank Schwieterman 2010-07-14 16:34:48

Thanks. One more thing - As far as I know I can have ashx handler or web service or WCF that can be called from jQuery to get the data back in JSON format. Which one would you prefer ashx or WCF? Which one is light weight or can give better performance?

shailesh 2010-07-14 17:13:10

Well I've used both and prefer ashx. WCF is a pain to configure and gets in the way most of the time. Using their OperationContract/WebInvoke to set up a restful service, input parameters must all be strings or lists of strings, I still have to write code to do serialization. POST parameters are still shuttled as form parameters, even if they are JSON encoded objects. Kind of yuk. An ASHX page implementation should be lightweight enough- just check the request verb, content type header, then deserialize the request body.

Frank Schwieterman 2010-07-14 18:08:45

ansaurus

tags:

views:

answers:

Generate JSON - how to improve performance

related questions