⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Slow Processing



tushar.rajpal.25

tushar.rajpal.25
  • profile picture
  • Member

Posted 20 March 2012 - 13:06 PM

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

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 20 March 2012 - 18:46 PM

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

gabb_roge
  • profile picture
  • Member

Posted 27 June 2012 - 20:45 PM

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

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 27 June 2012 - 23:25 PM

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

larasmith
  • profile picture
  • Member

Posted 16 April 2015 - 05:58 AM

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!