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

[Pat @ Pgogy]

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> 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] 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> 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] 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> 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] 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> 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
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
> _______________________________________________
> Xerte-dev mailing list
> 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
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
> 
> 
> 
> 
> 
> 
> _______________________________________________
> Xerte-dev mailing list
> 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
> 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/da98688b/attachment-0001.html>