It is currently Fri May 24, 2013 3:56 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 25 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: Fri Mar 30, 2012 9:10 pm 
 Post subject: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
As some of you have noticed, shuushuu has been running a bit slow recently. Today, we've pushed out some updates that will increase site performance. This will benefit the main page as well as searches by decreasing load and wait times.

To achieve these improvements we had to change the way page numbers are displayed. It's a bit less detailed than before but I think the gains will be worth it.

Let me know if you encounter any problems! ^^

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 7:11 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sat Mar 17, 2007 9:44 am
Posts: 2791
Location: NoWheRe
Searching by user name returned an error:

Code:
Message
No data supplied for parameters in prepared statement
Code
2031
File
/storage/www/e-shuushuu.net/common/functions/db.php
Line
380
Backtrace
Array
(
    [0] => Array
        (
            [file] => /storage/www/e-shuushuu.net/community/memberlist/index.php
            [line] => 90
            [function] => execute
            [class] => db_stmt
            [type] => ->
            [args] => Array
                (
                )

        )

)


Also for people who use Autopagerize or other extension like that, I have created a new XPath for E-shuushuu and submitted it to http://wedata.net/databases/AutoPagerize/

New XPath:
Code:
//div[@class='pagination']/ul/li[last()]/a


If people want to test, they can, and I would greatly appreciated it since I'm no expert in XPath. It should work, but I didn't test it intensively.

_________________
Image
Merun @ Twitter - Doujin Shimbun


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 9:53 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
Merun wrote:
Searching by user name returned an error:

Fixed.

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 10:09 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sun Sep 13, 2009 1:53 pm
Posts: 1146
Location: 絵 収集
Aham... might be because of this, so... http://e-shuushuu.net/image/0/ when it should come after http://e-shuushuu.net/image/488028/

Also when trying to upload something else,

Code:
Message
    Duplicate entry '0' for key 'PRIMARY'
Code
    1062
File
    /storage/www/e-shuushuu.net/common/functions/db.php
Line
    380

_________________
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 10:34 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sat Mar 17, 2007 9:44 am
Posts: 2791
Location: NoWheRe
Congratulation, you just broke Shuu's upload for everyone. Now that's some wonderful improvement for performance xD. No more uploads = faster!

Complete backtrace:

Code:
Message
Duplicate entry '0' for key 'PRIMARY'
Code
1062
File
/storage/www/e-shuushuu.net/common/functions/db.php
Line
380
Backtrace
Array
(
    [0] => Array
        (
            [file] => /storage/www/e-shuushuu.net/common/functions/uploadimage.php
            [line] => 144
            [function] => execute
            [class] => db_stmt
            [type] => ->
            [args] => Array
                (
                )

        )

    [1] => Array
        (
            [file] => /storage/www/e-shuushuu.net/upload/index.php
            [line] => 37
            [function] => submitFullImage
            [args] => Array
                (
                    [0] => /tmp/phpEWDQpi
                    [1] => 26220880.jpg
                )

        )

)

_________________
Image
Merun @ Twitter - Doujin Shimbun


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 11:06 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
With progress comes difficulty.

This has been fixed.

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 12:00 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sat May 30, 2009 11:43 am
Posts: 1851
Location: ひみつ
Can we have the option to go to the last page back or is an efficient mass tagging style (exclude the tag you're adding, start from back, images disappear when you add the tags, so you never double tag or miss anything) just SOL? :P

_________________
私は悪魔です。


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 12:08 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sat Mar 17, 2007 9:44 am
Posts: 2791
Location: NoWheRe
I think that optimizing the website implied the removal of the "last page" button ^^;

_________________
Image
Merun @ Twitter - Doujin Shimbun


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 12:24 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
Yatchen wrote:
Can we have the option to go to the last page back

Unfortunately, no. This change was required to fix performance issues.

Yatchen wrote:
or is an efficient mass tagging style (exclude the tag you're adding, start from back, images disappear when you add the tags, so you never double tag or miss anything) just SOL? :P

I've read this sentence a few times and I'm still not sure what you're trying to say ^^;

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 2:54 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Thu May 04, 2006 11:57 am
Posts: 2373
Location: Canton, Ga
anonymous_object wrote:
Yatchen wrote:
or is an efficient mass tagging style (exclude the tag you're adding, start from back, images disappear when you add the tags, so you never double tag or miss anything) just SOL? :P

I've read this sentence a few times and I'm still not sure what you're trying to say ^^;

She wanted the last page option back because many of the tagging team starts from the first page and work forward, rather than starting at the most current and working back. The last page button help with tagging old images more efficiently for images that weren't tagged properly before the tagging system was implemented.

_________________
C:/DOS
C:/DOS/RUN
RUN/DOS/RUN


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 3:34 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
Ran wrote:
She wanted the last page option back because many of the tagging team starts from the first page and work forward, rather than starting at the most current and working back. The last page button help with tagging old images more efficiently for images that weren't tagged properly before the tagging system was implemented.

Just reverse your sorting and start at page 1. This will achieve the same effect.

The issue is that the time to calculate the total number of pages for a complex set of images (like most searches) grows linearly as the number of records grows and the only way to show the last page link is to calculate the number of pages for a set of images. Shuushuu has reached a point where we have enough images, tags, and tag links that this is no longer efficient to do for every page load. This is why I have dropped the last page link.

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sat Mar 31, 2012 6:58 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Sat May 30, 2009 11:43 am
Posts: 1851
Location: ひみつ
Haha, sorry, I didn't think it would be very clear. Anyway, it's a really effective system, but oh well I guess. :P

_________________
私は悪魔です。


Top
 Profile  
 
PostPosted: Sun Apr 01, 2012 8:16 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Fri Sep 04, 2009 4:17 pm
Posts: 625
Location: Festung Europa
Is it possible that during update some images might be lost? I'm asking since my overall image post amount is off. At first I thought that it might be late refresh but when I checked today numbers haven't change.

_________________
Image

The nation having the strongest war footing can easily find an excuse for going to war.


Lewis F. Korns



Top
 Profile  
 
PostPosted: Sun Apr 01, 2012 11:17 am 
 Post subject: Re: Site changes - 03/30/2012
Offline
Site Admin
User avatar

Joined: Tue Jan 24, 2006 2:04 pm
Posts: 1577
Location: Good old US of A
Isoroku22 wrote:
Is it possible that during update some images might be lost? I'm asking since my overall image post amount is off. At first I thought that it might be late refresh but when I checked today numbers haven't change.

No, this should not have affected image counts. Where are you seeing these numbers?

_________________
e-shuushuu!
Image


Top
 Profile  
 
PostPosted: Sun Apr 01, 2012 12:12 pm 
 Post subject: Re: Site changes - 03/30/2012
Offline
User avatar

Joined: Fri Sep 04, 2009 4:17 pm
Posts: 625
Location: Festung Europa
I saw it on my profile, but it seems that it's alright now. After uploading today's share image post count is back to normal.

_________________
Image

The nation having the strongest war footing can easily find an excuse for going to war.


Lewis F. Korns



Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 25 posts ]  Go to page 1, 2  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
SubLite Theme By Echo -=Designs By Echo=- © 2007-2008 Echo
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group