40.000+ taxonomy...

The size of the node_access table will depend on how many nodes, and how many each is tagged with. The total number of terms doesn't matter. You don't want to write code to put values in there, instead you want to tag the nodes, then rebuild the node access table (drupal has a way to do that, I forget exactly).

Ok, the tid is written in the data field of the user... But that's only 8000 characters max...

i guess it's the string length then.

Is there a way to overcome this problem? Like changing the select list to an auto-complete text field where the user can just type the term that needs to be associated for the individual user's permission? Loading the page is really a huge performance setback. Or perhaps, integration with Hierarchical Select maybe?

Attached is a snippet that I'm currently using. It helps a lot in my case, with a huge collection of terms. Drupal doesn't have to load the whole vocabulary. Even worse if there are multiple schemes.

I'm imagining an integration with the Hierarchical Select module but I can't think a way through it.

Attachment	Size
tac.txt	23.32 KB

[^"]*)(?>""[^"]* )*"|(?: [^",]*))%x';
preg_match_all($regexp, $string, $matches);
$array = $matches[1];

// print_r($string); die();
// Fetch last tag
$last_string = trim(array_pop($array));
/*
$p=strrpos($string, ',');
if (!$p) $p=-1;
$last_string =trim(substr($string, $p+1));
*/
$matches = array();
//echo '--- '.$vid.' ---- '.$last_string;
if ($last_string != '') {
$result = db_query_range(db_rewrite_sql("SELECT t.tid, t.name AS name FROM {term_data} t WHERE t.vid = $vid AND t.name LIKE '%".$last_string."%'", 't', 'tid'), 0, 10);
$prefix = count($array) ? implode(', ', $array) .', ' : '';
while ($tag = db_fetch_object($result)) {
$n = $tag->name;
$parents = taxonomy_get_parents_all($tag->tid);
// Commas and quotes in terms are special cases, so encode 'em.
if (strpos($tag->name, ',') !== FALSE || strpos($tag->name, '"') !== FALSE) {
$n = '"'. str_replace('"', '""', check_plain($tag->name)) .'"';
}
if(count($parents)>1){
$parent_array = array();
$parents = array_reverse($parents);
array_pop($parents);
foreach($parents as $parent){
$parent_array[] = check_plain($parent->name);
}
$matches[$prefix . $n] = check_plain($tag->name) ." (".implode(" » ",$parent_array).")";
} else {
$matches[$prefix . $n] = check_plain($tag->name);
}
}
}
print drupal_to_js($matches);
exit;
}
$vocabularies = taxonomy_get_vocabularies();
$all_defaults = variable_get('tac_lite_grants_scheme_' . $i, array());

$form['tac_lite_grants_scheme_' . $i] = array('#tree' => TRUE);
foreach ($roles as $rid => $role_name) {
$form['tac_lite_grants_scheme_' . $i][$rid] = array(
'#type' => 'fieldset', //'textfield', //
'#tree' => TRUE,
'#title' => check_plain(t('Grant permission by role: !role', array('!role' => $role_name))),
'#description' => t(''),
'#collapsible' => TRUE,
'#autocomplete_path' => 'tac_lite/autocomplete/'.$form['#vocabulary']['vid']
);

$defaults = isset($all_defaults[$rid]) ? $all_defaults[$rid] : NULL;
foreach ($vids as $vid) {
$v = $vocabularies[$vid];
$form['tac_lite_grants_scheme_' . $i][$rid][$vid] = array(
'#type' => 'textfield',
//'#maxlength' => 10000,
'#title' => $v->name,
'#default_value' => get_terms_from_tids($vid, $defaults[$vid]),
'#autocomplete_path' => 'tac_lite/autocomplete/'.$vid);

}
}

$form['#submit'][] = 'tac_lite_admin_scheme_form_submit';
return system_settings_form($form);
}
else {
return (array('body' => array('#type' => 'markup',
'#value' => t('First select vocabularies on the settings page.', array('!url' => url('admin/user/access/tac_lite'))))));
}
}

function tac_lite_split_field($string, $vid){
// Add slashes first
$string = addslashes($string);
$regexp = '%(?:^|,\ *)("(?>[^"]*)(?>""[^"]* )*"|(?: [^",]*))%x';
preg_match_all($regexp, $string, $matches);
$string_array = $matches[1];
//echo 's: '; print_r($string_array);
return get_tids_from_terms($vid, $string_array);
}

/**
* Submit function for admin settings form to rebuild the menu.
*/
function tac_lite_admin_scheme_form_submit($form, &$form_state) {
//die('xxx');
$vids = variable_get('tac_lite_categories', NULL);
$vocabularies = taxonomy_get_vocabularies();
$schemes = variable_get('tac_lite_schemes', 1);
$roles = user_roles();
for ($i = 1; $i <= $schemes; $i++) {
foreach ($form_state['values']['tac_lite_grants_scheme_'.$i] as &$rid) {
//print_r($rid); die();
foreach ($vids as $vid) {
$rid[$vid] = tac_lite_split_field($rid[$vid], $vid);
}
}
}
variable_set('menu_rebuild_needed', TRUE);
}

function tac_lite_user_form_submit($form, &$form_state) {
//print_r($form_state['values']);die('xxx');
$x=array();
$x['tac_lite']=array();
$x['form_build_id']=$form_state['values']['_account']->form_build_id;
$vids = variable_get('tac_lite_categories', NULL);
foreach ($vids as $vid) {
$x['tac_lite'][$vid]=tac_lite_split_field($form_state['values'][$vid], $vid);
}
//print_r(serialize($x)); //die();
db_query("UPDATE {users} SET data='%s' WHERE uid=".$form_state['values']['_account']->uid, serialize($x));
}
$form['tac_lite_grants_scheme_' . $i][$rid][$vid] = array(
'#type' => 'textfield',
//'#maxlength' => 10000,
'#title' => $v->name,
//'#description' => $form['taxonomy'][$vid]['#description'],
'#default_value' => get_terms_from_tids($vid, $terms[$vid]),
'#autocomplete_path' => 'tac_lite/autocomplete/'.$vid);

?>

This works in individual page where you set their own permission settings.