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

Tom Reijnders reijnders at tor.nl
Thu Feb 28 10:25:06 GMT 2013


I'll have a look. I am not too familiar with Ajax and xot, but... one is 
never too old to learn ;-)

Tom

Op 28-2-2013 10:49, Julian Tenney schreef:
>
> 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
>
>
>
> _______________________________________________
> 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

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


More information about the Xerte-dev mailing list