[nilesht]

I have to run a simple operation. My table contains records of 24MB (appr 12334000 records). So while loading Grocery crud it not render grid and gives me error.

Now I want to use DISTINCT clause in select query as a solution. That is I want to do query "[b]SELECT DISTINCT(region1) from tbl_country_state_city[/b]".

Please, How can I do this so that I get desired results.

Thank you,
Nilesh

[victor]

what kind of error do you get?
I think you have to make your model

[victor]

if you want to reduce the load, you can read http://www.grocerycr...base/#entry2036

[bluepicaso]

can someone help with a simple model code example.