[Xerte-dev] Re: Changing Ownership in Management PHP

[Julian Tenney]

It still times out. I think we probably need to limit the searching to a particular user name, entered by the admin user. I think that makes more sense, I don't really need to browse all users LOs, would that be hard to do?

From: xerte-dev-bounces at lists.nottingham.ac.uk [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: 28 February 2013 08:59
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

There were a lot of queries inside loops. If you have say 8000 LO's and 800 users, it would do at least 8800 queries.

Try this one (this is a minor rewrite just re-arranging queries, it does 2 queries)

Tom
Op 27-2-2013 18:05, Pat @ Pgogy schreef:
Guess that page is timing out.

The page will need rewriting, or a new query doing I guess.

Pgogy Webstuff - http://www.pgogywebstuff.com
Makers of web things of a fair to middling quality

On 27 Feb 2013, at 16:23, Julian Tenney <Julian.Tenney at nottingham.ac.uk<mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
This is what happens:

<image001.png>

Nothing more.

From: xerte-dev-bounces at lists.nottingham.ac.uk<mailto:xerte-dev-bounces at lists.nottingham.ac.uk> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 27 February 2013 14:41
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Management.php is all ajaxed - so the front page should work regardless.

You can watch the speed of requests in console in firebug or chrome to see if that is a problem

Pgogy Webstuff - http://www.pgogywebstuff.com
Makers of web things of a fair to middling quality

On 27 Feb 2013, at 13:36, Julian Tenney <Julian.Tenney at nottingham.ac.uk<mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
I had thought it was due to the size of the database, because I noticed it really starting slow up as the number of LOs increased - we have about 8000 now. Does management.php work OK on the sandpit On? You've got a similar number of LOs in there haven't you?

From: xerte-dev-bounces at lists.nottingham.ac.uk<mailto:xerte-dev-bounces at lists.nottingham.ac.uk> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 27 February 2013 12:53
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Yes changing ownership has been there for ages.

If it freezes it suggests a JavaScript problem has occurred

Pgogy Webstuff - http://www.pgogywebstuff.com
Makers of web things of a fair to middling quality

On 27 Feb 2013, at 11:56, Julian Tenney <Julian.Tenney at nottingham.ac.uk<mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
Can I change ownership in management.php? When I log in, it just appears to freeze, clicking any of the top menus doesn't appear to do anything,




_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk<mailto:Xerte-dev at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk<mailto:Xerte-dev at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
_______________________________________________
Xerte-dev mailing list
Xerte-dev at lists.nottingham.ac.uk<mailto:Xerte-dev at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev







_______________________________________________

Xerte-dev mailing list

Xerte-dev at lists.nottingham.ac.uk<mailto:Xerte-dev at lists.nottingham.ac.uk>

http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev



--

--



Tom Reijnders

TOR Informatica

Chopinlaan 27

5242HM Rosmalen

Tel: 073 5226191

Fax: 073 5226196


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/e6abd1fd/attachment.html>