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

[Pat @ Pgogy]

Oh I wasn't missing it, but I've had all my vaccinations topped up recently so am immune to doing lots of work for free :)

I think there are a few things that aren't built to scale all that well - the management side of things has always been a bit untested though. It was written years ago, in that days of 200 LOs and so on

Pgogy Webstuff - http://www.pgogywebstuff.com

On 28 Feb 2013, at 09:49, Julian Tenney <Julian.Tenney at nottingham.ac.uk> wrote:

> 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> 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
> _______________________________________________
> 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/57fb13ab/attachment.html>