[tushar.rajpal.25]

Why the processing is slow. It is taking a lot of time to show the entire data. Else It is rocking. Any suggestion or alternative to this problem?

[web-johnny]

Probably you use the datatables theme. The datatables is cilent-side scripting. This means that all the data are preloaded. If you want fast server-side queries use flexigrid (the default theme)

[gabb_roge]

Hi there! I tried with flexigrid theme and it reduced the processing time but it continues be slow compared it with the most of the queries time. Any suggestion or the pretty slow processing is normal?

[web-johnny]

It depends of how complex your query is. For example if you have lot of set_relation and set_relation_n_n in your function perhaps it will take more time to load. Also there is one thing that I have changed to the last versions and maybe if you change it can do the queries a bit faster. You take a look at: /topic/497-adding-set-relation-results-in-a-time-out-from-the-database/#entry2036 to see if it will work fine for you . In general I try to optimize each query with the best way.

If you think that you can change the query and make it faster you can use set_model and change some of the queries without actually changing the core functionality of grocery CRUD.

[larasmith]

I'm using flexigrid too it takes about 25 seconds to load. The details of my problem is under this topic:

7k records slow loading/processing using flexigrid

/topic/3010-7k-records-slow-loadingprocessing-using-flexigrid/#entry12360

Please help! Thanks!