ParamQuery grid support forum

General Category => Help for ParamQuery Grid (free version) => Topic started by: noctrona on February 28, 2014, 07:57:06 am

Title: Efficiency of load/render data by array and json
Post by: noctrona on February 28, 2014, 07:57:06 am

Hi,

We will use this plugin in a new project. And we want to choose a way to CRUD data from database between array and json.

For the moment, I queried records from our database and handle them as json format on my page.(I get result from background and handle them as json format on my page)

So I want to ask you if we have lots of records need to display or CRUD which way has a higher efficiency? So far as I know, the may be several hundred. May be more in the future.



Thank you!

Title: Re: Efficiency of load/render data by array and json
Post by: paramvir on February 28, 2014, 09:09:55 am

Generally arrays are faster than JSON, but that makes little difference in the context of pqGrid because most of its time is spent in rendering the view.

pqGrid can handle hundreds of thousands of records for view or CRUD for both JSON and array.

It's better to go with JSON considering it makes for better readability and easiness in testing of code.

Title: Re: Efficiency of load/render data by array and json
Post by: noctrona on February 28, 2014, 11:56:49 am

Quote from: paramquery on February 28, 2014, 09:09:55 am

Generally arrays are faster than JSON, but that makes little difference in the context of pqGrid because most of its time is spent in rendering the view.

pqGrid can handle hundreds of thousands of records for view or CRUD for both JSON and array.

It's better to go with JSON considering it makes for better readability and easiness in testing of code.

Thanks for your suggestion.