i have a question about set_relation_n_n function and rendering of the results.
The scenary is a blog about movies, just same as your example.
My code is something like this
$crud->set_theme('datatables'); $crud->set_table('movies'); $crud->set_relation_n_n('actors', 'people_movies', 'people', 'movie_id', 'people_id', 'name', 'role')->where('role','regista'); $crud->set_relation_n_n('categorie', 'categories_movies', 'categories', 'movie_id', 'category_id', 'name'); $crud->fields('title', 'actors', 'categorie'); $output = $crud->render();
People table counts is 5k+ rows, Movies table count is 400+ rows, Categories table count is 20 rows.
Join query between categories, movies and peoples took about 0,002 sec on my database, so it's not a db issue.
My problem is that when the browser try to render the page, a script in the page send the browser in timeout.
What do you think about it?
Thanks in advance for your answer, and sorry for my bad english.