⚠ 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

How to limit data on grid



randori21
  • profile picture
  • Member

Posted 13 June 2012 - 10:15 AM

I have problem on showing data more than 1500 records, process become slowly. I try using limit but it doesnt work. Could I showing limit data but when on search box typing something it search all data which contain it data? Thanks.

fdias
  • profile picture
  • Member

Posted 13 June 2012 - 17:17 PM

/topic/578-workaround-problem-with-crud-limit-doesnt-work-properly/

Check out this link.

Hope it helps.

Cheers

fdias
  • profile picture
  • Member

Posted 13 June 2012 - 17:19 PM

[quote name='randori21' timestamp='1339582529' post='2278']
Could I showing limit data but when on search box typing something it search all data which contain it data? Thanks.
[/quote]

Regarding this second part of your question I don't believe it's possible now, because the search feature is within the data that has been polled from the database and by using limit you are not selecting anything else.

I sugest you use limit and have a button to allow users to see all records or a separate search.

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

Posted 13 June 2012 - 22:55 PM

I think [member='randori21'] if you just change theme from datatables back to flexigrid theme (default) it will be fine. Datatables use client-side scripting so this means that you will wait till all the data loads ones.