till, I need a little guidance here. Can i have the index definitions for the following fields from the database. userid groupid doctype_id tree_id type doc_id this is from the isp_nodes table. Are the Isp_fakt_nodes and isp_fakt_artikel the only tables used for the invoiceing ? Do you have any documentation how your billing system functions ? Flow charts ? anythin ? tony
userid = id of the users, see sys_user table. groupid = The groupid if the user, see group table. doctype_id = doctype ID, see doctpye table tree_id = primary ID of the *_nodes table type = type of the node. There are two types, one for nodes and one for folders. doc_id = the doc_id of the object were this node is for, see isp_isp_web, isp_isp_domain etc. everything with isp_fakt_* is for the invoicing. no.
