I Fill a dataset by sql query and the dataset contains a large datatable. DataSet dataSet1 = new DataSet(); SqlDataAdapter ndaGlobalClass = new SqlDataAdapter(Query, cn); ndaGlobalClass.SelectCommand.CommandTimeout = 0; cn.Open(); ndaGlobalClass.Fill(dataSet1); cn.Close(); string s=JsonConvert.SerializeObject(dataSet1.Tables); the Query return a large datatable and when i convert it to json by serializing System.OutOfMemoryException' was thrown. Rock Plaza Central Are We Not Horses Rare. How can i fix this problem? I need to serialize large datatable and there is no circular issue. If you are using a large data table and you are getting out of memory issues, it may well be that the size of the JSON string is just too big for.NET - there is a limit of 2GB on any single object in.NET, and since JSON is a text-based serialization a large table could well exceed that even if the 'raw' data table is considerably less than that. Download Matlab Free Full Crack more. Try an experiment: find out how many rows the table holds, and modify your query to return only half that: SELECT TOP nnn should do it.
Predicting performance, 415–418 scaling, 412 shared resources, 404–412 EJBS, design patterns for, 521–525 caching services, 523 combining EJBs, 523 CPU usage, 525 Data Access Objects, 522 efficient transfer of large datasets, 522 load balancing, 525 message handling, 525 reducing locking conflicts, 524 reusing. OutOfMemoryError: Java heap space at java.util. JavaSerializerInstance.serialize(JavaSerializer.scala:73) at org.apache.spark.executor. I don't know how much memory you gave it, but if your machines have 512MB memory (total?) a 250MB data set, accounting for Java overhead, probably blows.
Comments are closed.