Webmastersite.net
Register Log In

Few Questions about WSN Links
Before purchasing

Comments on Few Questions about WSN Links

pixelsoul
Member

Usergroup: Customer
Joined: May 24, 2005

Total Topics: 1
Total Comments: 16
#16 - Quote - Permalink
Posted May 31, 2005 - 4:36 AM:

This is also ver strange on the server with the entire table:

Load time so far: 0.95 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnl_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,100;

Number of rows is 56 for Resource id #24

Load time so far: 1.3 seconds.
Performing query: SELECT id FROM wsnl_categories WHERE parent=0 AND validated=1 AND hide=0 ;

Number of rows is 56 for Resource id #25

Load time so far: 7.82 seconds.
Performing query: UPDATE wsnl_sessions SET starttime='0' WHERE time < 15;


It seems it takes 7 seconds to get 56 categories :s
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#17 - Quote - Permalink
Posted May 31, 2005 - 11:03 PM:

pixelsoul wrote:
Edit* Nevermind its the gzip compression which is buggy, when turned on you cant view any of the pages.


It's not a bug actually, read the manual entry.


Your admin queries total to 1-2 seconds. That's slower the usual, but not that bad.

How your categories query can be that slow, I wouldn't know. Maybe the table is indexed wrong or exceptionally badly optimized somehow.
pixelsoul
Member

Usergroup: Customer
Joined: May 24, 2005

Total Topics: 1
Total Comments: 16
#18 - Quote - Permalink
Posted May 31, 2005 - 11:50 PM:

sad hmm this is how the table looks, i optimized it with php my admin but little changed:

Offcourse this is just a small piece of it, but you will notice a lag allready, query time of 2 secondsup to 4 sec....raised eyebrow

Attached Files:
pixelsoul
Member

Usergroup: Customer
Joined: May 24, 2005

Total Topics: 1
Total Comments: 16
#19 - Quote - Permalink
Posted May 31, 2005 - 11:59 PM:

shaking headHmmm i just emptied the entire category table and this is the resukt:

19 total queries
This page was created in 1,1010019779205 seconds

1,1 second to load nothing sad

This is where it takes up allot of time for nothing?


Load time so far: 0.4 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;


Load time so far: 0.46 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;


And with some test data shocked


Load time so far: 1,15 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;

Number of rows is 344 for Resource id #43

Load time so far: 1,16 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnlinks_categories WHERE id=1 ;

Load time so far: 117,3 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;


24 total queries
This page was created in 122,9527721405 seconds
pixelsoul
Member

Usergroup: Customer
Joined: May 24, 2005

Total Topics: 1
Total Comments: 16
#20 - Quote - Permalink
Posted Jun 08, 2005 - 7:14 AM:

disapprovalNevermind we are going for a custom solution this script is just waaaaay to slow.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#21 - Quote - Permalink
Posted Jun 11, 2005 - 12:07 PM:

Suffice it to say that it obviously doesn't take 122 seconds to load in any reproducable situation no matter how much data, except possibly if you add a billion toplists or import data directly to the database without following the instructions to regenerate. Nobody else has had your problems.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.