A call to voltExecuteSQL() to run sql queries will return a VoltTable[]. As per documentations, each column being referred in the query will have the FieldName and the Value associated with it.
For example, "Select Name, Class from Student" will return a table of the sort
Name, A | Class, X
Name, B | Class, X
So what is the motive behind appending column names to each value in the result. That obviously makes up for a result set of larger size. I have a feeling that doing away with it will help reduce that error which says only 100MB allowed in results.
Kindly explain.
For example, "Select Name, Class from Student" will return a table of the sort
Name, A | Class, X
Name, B | Class, X
So what is the motive behind appending column names to each value in the result. That obviously makes up for a result set of larger size. I have a feeling that doing away with it will help reduce that error which says only 100MB allowed in results.
Kindly explain.
Comment