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

[Tom Reijnders]

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
> 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/ed6b7990/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: user_templates.php
Type: application/x-httpd-php
Size: 6405 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/ed6b7990/attachment-0001.bin>