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

[Julian Tenney]

I think you might be missing the subtle manager speak in ‘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 Pat @ Pgogy
Sent: 28 February 2013 09:37
To: For Xerte technical developers
Subject: [Xerte-dev] Re: Changing Ownership in Management PHP

Rewrite the query as a list of usernames, make the username an Ajax function which fires and then returns just the data for that user

One new js function, and splitting the existing php into two files

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

On 28 Feb 2013, at 09:08, Julian Tenney <Julian.Tenney at nottingham.ac.uk<mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
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> [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




_______________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/362209b9/attachment-0001.html>