the sql goes crazy on large databases. It even takes ages to complete on my test database with maybe a hundred tasks. In the updated (from 3.0.0) large db, it looks like the getTasksForPeriod() returns millions of tasks before going into the foreach testing which to display.\nAlso, there is a load before the function testing that canAcess, and in the function there is another this->load, so many redundent operations. $obj->load($row['task_id']); $canAccess = $obj->canAccess(); and there: public function canAccess($user_id = 0) { $this->load($this->task_id); yes, this w2p user has many tasks where he is assigned to, and the old code took long, but at least did complete. Now I think the webserver goes into a timeout. For the test database, even here it takes 20sec+ (withdebugger) to display the dayview tab with events. Switching to the tasks tab in dayview takes anther 30 (?) seconds on the 100 (?) tasks. Too much redundant queries? Or query cache too small? But it runs on a standard bitnami wampstack (production server) or wampserver (my notebook), and at least bitnami is set resonably - don't remember, but I adapted it and it is definitely not mysql small, rather medium or so. any ideas? This is a block as far as large production databases are concerned. also, it seams that retrieving the $company_id at the top of event-index.php needs a typecast to int, at least on my system. Klaus

asked 11 Apr '14, 14:51

opto's gravatar image

opto ♦
83343110131
accept rate: 10%

asked 11 Apr '14, 14:51


this set of tasks (see picture) originally took 45 sec. I modified the code for redundancy and got down to 35sec (20% improvement). The tasklinks take 20s.\nIt's a lot of tasks, but: 7200 queries?ACLs take 17 s? Due to debugger, this takes longer, but still: on my production database, this is not usable if participant to many tasks. see my branch canAccess_Speed_Optimisation at github: opto/web2project. ![speed][1] ![tasks][2] [1]: /storage/temp/141-queryspeed.jpg [2]: /storage/temp/142-tasks.jpg
permanent link

answered 11 Apr '14, 17:05

opto's gravatar image

opto ♦
83343110131
accept rate: 10%

answered 11 Apr '14, 17:05

Pull requests merged.. significant improvement already. Nice job.

(13 Apr '14, 02:28) caseydk ♦♦ caseydk's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×17
×8
×7
×7

question asked: 11 Apr '14, 14:51

question was seen: 762 times

last updated: 13 Apr '14, 02:28

powered by Bitnami OSQA