c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <771941@xxxxxxxxxxxxxxxxxx>]

well if you have some 1000 or 10000 lines in 
class project_work(osv.osv):
postgress will have to make full table scans if no index on task/user etc exists.

example 
task list has to calculate progress
def _hours_get ...

basically if tables are getting bigger we will want to turn off the
autosearch feature because of perofmrance and to not display unwanted
data (1) and select only specific project/tasks

(1) autosearch feature should be turned of for big tables as mentioned already multiple times
especially on slow and/or expensiv (mobile, abroad) lines it does not make sens to transfer a set of 80 records first , enter the querey and get the wanted data. IMHO this is wasting resources (time/cost) of computers, networks and users.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/771941

Title:
  project_task_work needs some more indices

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  things are a bit slow without indices , it's likely to be a big table

  class project_work(osv.osv):
      
       _columns = {
          'date': fields.datetime('Date', select="1"),
          'task_id': fields.many2one('project.task', 'Task', ondelete='cascade', required=True, select="1"),
          'user_id': fields.many2one('res.users', 'Done by', required=True, select="1"),