UPGRADE from 2.2.3 to 2.6.1 - Upgrade Rows while Component I

[hmayer1980]

Hi,

just did my fist test-upgrade from 2.2.3 to 2.6.1.
(and joomla 1.5.11 to 1.5.15)

While Installing the new Component you need to upgrade rows from images and categories - this is done at 100 Rows per Click.

I have got some 45000 Images - results in 450 Clicks - not so funny!

I have seen an URL Query Parameters for the number of images - is it save to change it to 1000 for example and reload the same page (upgrade would run for 100 images twice) - is this save and OK.
It is definitly save in case of server execution time in my case because I got no erros from php or apache.

Or are there other parameters I could change save to do some 1000 or 10000 rows per click - thats never a big deal for mysql performance and script execution time. You did write you could have potentialy a lot of rows - so I definitly think 100 per click is way to less.
Maybe my phoca upgrade issues result from this, but I do not think so - see further posts.

Thanks for a Hint.
Hannes Mayer

[Jan]

I have got some 45000 Images - results in 450 Clicks - not so funny!

I believe, but cannot do anything. As the code is not made for only one site but can be used on different servers, there is used pagination. In fact no server can handle the 45000 images at once. As the server will be not able to covert all them in one script, there must be some pagination As I don't know on which server it will be run, the lowest pagination needs to be selected. Selecting pagination 20 (as this is normally used in Joomla!) will be more difficult , so the 100 is the largest value which you e.g. can find in Joomla! Yes not ideal for large galleries but it is some kind of compromise

Jan