[Ritesh Singh]

I have a table with more than 9 million records, it is taking about 14 seconds in listing...

 

 

how can i reduce this..please help...

[Amit Shah]

Well this is a topic exclusively based on system optimization and not the functionality of GC

 

There are many ways you can optimize and there can be many reasons why it is taking so much of time.. unless some expert may look into the existing system.. its going to be tough explaining a generic process... how to improve the performance..

 

However .. i you can go through my postings.. u may find somewhere in past 2-3 months of my contributions where i shared up a pattern for system optimization..

 

Happy GCing :) ... and happy forum surfing :)

[Ritesh Singh]

Thanks for the reply Amit...

actual problem is related to pagination..i want pagination to work in limits instead of loading whole data, then dividing into pages.

in my case i think whole record is loading resulting into slow listing.

 

 

basically i wan't to customize pagination, i did in core php but don't know how to implement in grocery crud.

 

i want that on click of next page, list query should run again with change in limits..

 

 

 

Thanks in Advance.

[Amit Shah]

From what you speak .. it seems you using datatables.. and if thats the case i will recommend you using flexigrid as it is more ajax driven and limits the data to required. That may solve your problem.

[Ritesh Singh]

Thanks Amit, that solved my problem...

 

 

Thanks a lot......